I compiled up your code and ran it on Windows using VC6 and got: a 98 Hope this helps Dan
-----Original Message----- From: Marco Bambini [mailto:[EMAIL PROTECTED] Sent: 31 October 2007 09:33 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version No, the database is created by the code it doesn't already exists. I was able to reproduce the issue only on Windows, Mac and Linux worked fine. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 10:25 AM, Stephan Beal wrote: > On 10/31/07, Marco Bambini <[EMAIL PROTECTED]> wrote: >> >> ... >> On Windows (not on Mac!) it returns 99 instead of the correct 98 >> value. >> Anyone can confirm that on Windows? > > > Hi, Marco! While i can't confirm how it behaves under Windows, i can > confirm that it returns 98 on Linux: > > [EMAIL PROTECTED]:~/tmp$ gcc -o win -I$HOME/include win.c -L$HOME/lib - > lsqlite3 > [EMAIL PROTECTED]:~/tmp$ ./win > a > 98 > simple test finished! > > i quickly scanned through your code and found no reason that 99 should > come up. > > One thing to check: does your test.sqlite DB already exist o your > windows box, with a record already in it? That would explain the > discrepancy (but if that were the case, the CREATE TABLE call should > fail, so that's probably not the problem). > > -- > ----- stephan beal > http://wanderinghorse.net/home/stephan/ ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------