Re: [sqlite] concurrent write

Hello! В сообщении от Saturday 29 November 2008 04:12:06 Richard Kim написал(а): > Thanks for your link, but it is not really click me too well > I should set this busy_timeout to longer ms than current ? Set timeout to 2000, for start. Best regards, Alexey. _

[sqlite] Usage of sqlite3_exec in VB6

Hi, I am new to SQLite. I see when I tried to use the sqlite3_exec function, my application is crashing. When I use the same command in a cmd line interface(sqlite3>) then it works fine. Is there any restriction on the number of fiedls in a database. Please provide me the pointers to debug t

Re: [sqlite] Usage of sqlite3_exec in VB6

On Sat, 29 Nov 2008 08:20:29 -0800 (PST), S Thiyagarajan <[EMAIL PROTECTED]> wrote in [EMAIL PROTECTED], General Discussion of SQLite Database : >Hi, > >I am new to SQLite. And to this mailing list, obviously. You just hijacked another thread. http://www.nabble.com/Mailing-list-Thread-Hijacking-

[sqlite] Select Limit issues

I have never posed in a group before forgive me if I am out of line with my question. I have a table called table1 With three fields: Field1, Field2, Field3 Here is my query but I get errors. Any help work be great select field1, field2 from ( select * from ee_table1 where field2 = 'blue' lim

Re: [sqlite] Select Limit issues

On 11/29/08, Webmaster <[EMAIL PROTECTED]> wrote: > I have never posed in a group before forgive me if I am out of line with my > question. > > I have a table called table1 > With three fields: Field1, Field2, Field3 > > Here is my query but I get errors. > Any help work be great Please provi

Re: [sqlite] Select Limit issues

"Webmaster" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > select field1, field2 from > ( select * from ee_table1 > where field2 = 'blue' limit 1 > and field1 < (select min(field1) from (select * from ee_table1 > where field2 = 'white' limit