Re: [sqlite] Trouble with Memory DBs

2006-04-06 Thread Brett Goodman
Thanks all for your responses. Here is what I have found:  If I open a mem DB with sqlite3_open using NULL as the filename, then use sqlite3_prepare16, the function fails with "ErrMisuse".  But I can use sqlite3_prepare (etc.).   But if I use sqlite3_open with ":memory:" then I can use sqli

Re: [sqlite] Trouble with Memory DBs

2006-04-06 Thread Brett Goodman
And now I find that if I open a mem DB with sqlite3_open then use sqlite3_prepare16, the function fails with "ErrMisuse" Any ideas? Quoting Brett Goodman :     Hello all. I'm having some trouble with memory DBs. The documents that I find on the website say to use ":memory" as t

Re: [sqlite] Trouble with Memory DBs

2006-04-06 Thread Nuno Lucas
On 4/7/06, Brett Goodman <[EMAIL PROTECTED]> wrote: >Hello all. I'm having some trouble with memory DBs. The documents > that I find on the website say to use ":memory" as the filename in > the call to sqlite3_open. But the only way I can make the function > succeed is by passing NULL. > Furthe

RE: [sqlite] Trouble with Memory DBs

2006-04-06 Thread Boris Popov
Try, :memory: Cheers! -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that i