Re: [sqlite] SQL POSITION function?

2008-09-02 Thread Liam Healy
I think charindex in extension functions might do what you want; see extension-functions.c in http://sqlite.org/contrib. Liam On Tue, Sep 2, 2008 at 6:20 PM, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any plans on adding a string matching function like the SQL99 > (E021-11) "POSITION" > > -- > Jim D

[sqlite] SQL POSITION function?

2008-09-02 Thread Jim Dodgen
Any plans on adding a string matching function like the SQL99 (E021-11) "POSITION" -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] "cannot commit transaction"

2008-09-02 Thread tomcondon
I am having the "cannot commit transaction - SQL statements in progress" issue. I have read through the mailing list and cannot find a solution to my problem. My problem: I am running, through some prepared statements (with single threaded code) a select statement, an insert statement, a s

Re: [sqlite] how to unsubscribe

2008-09-02 Thread Mihai Limbasan
Winanjaya wrote: could any body please advise.. how to unsubscribe from this list? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users You can change subscription options at your ma

[sqlite] how to unsubscribe

2008-09-02 Thread Winanjaya
could any body please advise.. how to unsubscribe from this list? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.6.1 memory leak?

2008-09-02 Thread Ulric Auger
Thanks Eric for your help. You are right sqlite3_shutdown() fixed the memory leak under 3.6.1. I tested SQLite 3.6.2 and it does not leak even if I don't call sqlite3_shutdown. I will proceed with SQLite 3.6.2 Ulric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On