Re: [sqlite] Extracting values from callback

2004-11-05 Thread Guy Hachlili
Well... At 22:23 11/5/2004 +0100, you wrote: I've been trying at this for a good few hours now, I'm using sqlite3 and the quick start code at the website. By using a global "char *buffer[5][220];" and then doing buffer[i][counter]=argv[i]; I thought I would be able to extract the rows in my

Re: [sqlite] Extracting values from callback

2004-11-05 Thread Daniel K
> static int callback(void *NotUsed, int argc, char > **argv, char **azColName){ > int k; > rows=argc; > for(k=0;k { > buffer[k][counter]= argv[k]; > } > counter++; > return 0; > } The data pointed to by argv[k] only exists for the duration of the

Re: [sqlite] Large memory usage not freed?

2004-11-05 Thread Brett Granger
[EMAIL PROTECTED] wrote: On Nov 4, 2004, at 3:42 PM, D. Richard Hipp wrote: If we exit the process and then reopen the database in a new process, all that memory is not reallocated. Are you sure you have that right? What OS are you running? Oops, tracked it down on our side... multi-threaded

Re: [sqlite] Pocket PC - SQLite - eMbedded Visual C++ YES IT IS POSSIBLE

2004-11-05 Thread Steve Frierdich
Yes Aaron it is possible. We use SQLITE 3.0.7 on Pocket PC OS Version 3.0 Steve Aaron Planell López wrote: Hi: I'm trying to create an eMbedded Visual C++ application for Pocket PC using SQLite. Is it possible? Thanks! Atentamente, Aaron Planell López Principal:[EMAIL

[sqlite] Extracting values from callback

2004-11-05 Thread aleks ponjavic
I've been trying at this for a good few hours now, I'm using sqlite3 and the quick start code at the website. By using a global "char *buffer[5][220];" and then doing buffer[i][counter]=argv[i]; I thought I would be able to extract the rows in my table but it does not work. When the program has

Re: [sqlite] SQLite For Personal Use

2004-11-05 Thread Dmytro Bogovych
On Fri, 05 Nov 2004 12:48:56 -0500, Jeff Flowers <[EMAIL PROTECTED]> wrote: Is anyone using SQLite to manange personal data; not as part of another program but by itself, as distributed with the sqlite frontend? I searched Google but no one seems to be talking about SQLite as a program by

RE: [sqlite] Version differences between sqlite 2.7.6 , 2.8.0 . 2.8.5

2004-11-05 Thread Srinivas Koppisetti
Great.. do you think copying over datafiles to a different OS will be an issue. -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 1:41 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Version differences between sqlite 2.7.6 , 2.8.0 . 2.8.5

Re: [sqlite] SQLite For Personal Use

2004-11-05 Thread Ara.T.Howard
On Fri, 5 Nov 2004, Jeff Flowers wrote: Is anyone using SQLite to manange personal data; not as part of another program but by itself, as distributed with the sqlite frontend? I searched Google but no one seems to be talking about SQLite as a program by itself. i do. anytime i have to manage data

[sqlite] sqlite.so for php 4

2004-11-05 Thread Anton Wolkov
can anyone send me sqlite.so for php 4, i can't compile it on the target machine cause i don't have permissions, i can't compile it on my home machine cause i got php 5. u can upload it via www.yousendit.com if you don't wanna send files to the group. thanks

Re: [sqlite] Version differences between sqlite 2.7.6 , 2.8.0 . 2.8.5

2004-11-05 Thread D. Richard Hipp
Srinivas Koppisetti wrote: Hi, Has any one tried to use V2.76 database files with 2.85 binary on solaris. Are there any known issue in doing so? 2.7.6 and 2.8.0 should be fully compatible. The only difference is in the format of the rollback journals. There are no file format changes from

Re: [sqlite] Version differences between sqlite 2.7.6 , 2.8.0 . 2.8.5

2004-11-05 Thread Clay Dowling
Srinivas Koppisetti said: > Hi, > Has any one tried to use V2.76 database files with 2.85 binary on solaris. > Are there any known issue in doing so? > > I am trying to upgrade my binary to 2.85 or latter. Any info about this is > great.. I don't know about file level compatibility, but the

[sqlite] Version differences between sqlite 2.7.6 , 2.8.0 . 2.8.5

2004-11-05 Thread Srinivas Koppisetti
Hi, Has any one tried to use V2.76 database files with 2.85 binary on solaris. Are there any known issue in doing so? I am trying to upgrade my binary to 2.85 or latter. Any info about this is great.. Thanks, Srinivas' ===

Re: [sqlite] Pocket PC - SQLite - eMbedded Visual C++

2004-11-05 Thread Mateusz Łoskot
Yes, it is. I use sqlite-wince port (you'll find on http://sourceforge.net). It compiles with eVC++ 3.0 and 4.0 successfuly. I also compiled it using Intel compiler for Windows CE (formely, for embedded VC++). Greets -- Mateusz Łoskot, mateusz (at) loskot (dot) net Registered Linux User #220771,

Re: [sqlite] compiler warnings

2004-11-05 Thread Cory Nelson
send in a patch ;) On Fri, 5 Nov 2004 08:33:51 -0600, Stober, Mel <[EMAIL PROTECTED]> wrote: > When I compile the 3.0.8 source with VC++ 6.0 (SP5 installed) compiler as a > DLL, the compiler spews out 131 warnings about type mismatch, integral size > mismatch, conversion from '__int64 ' to 'int,

[sqlite] compiler warnings

2004-11-05 Thread Stober, Mel
When I compile the 3.0.8 source with VC++ 6.0 (SP5 installed) compiler as a DLL, the compiler spews out 131 warnings about type mismatch, integral size mismatch, conversion from '__int64 ' to 'int, and a host of other miscellaneous warnings. Any thoughts about the SQLite project programmers

Re: [sqlite] sqlite3_changes() != 0 after SELECT

2004-11-05 Thread Ben Summers
D. Richard Hipp wrote: Ben Summers wrote: > Hi, > > I'm finding that in version 3, sqlite3_changes() != 0 after a SELECT query has been executed. What's the query? I found this in a simple program which tests my database interface code. The table is CREATE TABLE tTest1 ( fID INTEGER

Re: [sqlite] sqlite3 error in kexi-0.1beta5

2004-11-05 Thread Daniel Franke
> kexi: btree.c:1043: sqlite3BtreeOpen: Assertion > `sizeof(ptr)==sizeof(char*)' failed. KCrash: Application 'kexi' crashing... See also: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg04718.html http://bugs.kde.org/show_bug.cgi?id=92563 Daniel -- Dipl.-Math. (FH) Daniel