Re: [sqlite] how to get the INTEGER PRIMARY KEY for the row just inserted?

> begin immediate; insert; select max(id) from blah; commit; Or "select last_insert_rowid() from blah limit 1" Regards

Re: [sqlite] Access Violations in sqlite3_step when in DLL

> Sounds like the calling type is different. Do you know if the EXE is > calling your stuff using stdcall or cdecl, and does it match your > functions? If you don't specify, your functions are cdecl. I've seen > this kind of thing when they don't match. It may work a couple of > times, but

Re: Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

Thanks Jay. Great! This could work... I'm wondering, though if you know whether the limitation below (from sqlite documentation) could be safely circumvented if attaching the source db with an alias name. It seems to work when i try it but I'm concerned that there might be other unknown

Re: [sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

Did you try attach and an insert? --- de f <[EMAIL PROTECTED]> wrote: > I'd like some guidance on the most efficient way to copy a large > table from one slqite db to another. I'm using from within vb > with a vc++ sqlite wrapper. > > I know that the copy command is no longer available in

Re: [sqlite] how to get the INTEGER PRIMARY KEY for the row just inserted?

The documentation is your friend. long long int sqlite3_last_insert_rowid(sqlite3*); http://sqlite.org/capi3ref.html#sqlite3_last_insert_rowid or begin immediate; insert; select max(id) from blah; commit; --- jack wu <[EMAIL PROTECTED]> wrote: > i have a table which has an ID column defined

[sqlite] How do I efficiently copy tables to another db within dll (sqlite3+)

I'd like some guidance on the most efficient way to copy a large table from one slqite db to another. I'm using from within vb with a vc++ sqlite wrapper. I know that the copy command is no longer available in ver3+ and am unsure of how to proceed. do i need to somehow hook into the

[sqlite] how to get the INTEGER PRIMARY KEY for the row just inserted?

i have a table which has an ID column defined as INTEGER PRIMARY KEY. I'd like to know the value of the automatically generated ID right after the insert. is there anyway to get the ID without issuing another select? does the insert function return the ID in any way? if another select is

Re: [sqlite] Reading Database Schema Info. in Perl

On 30 Mar 2005, at 04:05, [EMAIL PROTECTED] wrote: I need to be able to read all table names in the database, and further all attribute names in each table. ( am using DBD::SQLite in Perl) For gathering all the table names I've used the sqlite_master table. The problem is that the information on

Re: [sqlite] Access Violations in sqlite3_step when in DLL

On Apr 5, 2005 6:54 AM, Chris Schirlinger <[EMAIL PROTECTED]> wrote: > Recently we tried to tie in with a third party program that calls one > of our DLL's (which access the SQLite3 DB and returns a data set) > [Note: We eventually started a fresh project for this DLL, so there > was less of a

[sqlite] Access Violations in sqlite3_step when in DLL

We have been using SQLite3 for a while now without issues. We are running a EXE calling a DLL (Which calls a DLL which eventually uses the SQLite functions) These two DLL's are both written in Delphi - in Windows (with a delphi wrapper that runs the SQLite DLL) This code has worked fine under

[sqlite] assertion failing in pager.c :(

Hi, Can anybody help me with this problem I want to know why the assert statement assert( pPg->nRef==0 || pPg->pgno==1 ); is written in the pager_playback_one_page() function in the pager.c file(line no:573). That assertion is failing when the memory is low. To be more explanative while memory

RE: [sqlite] ANN: Sqlite3Explorer

good idea. so, let me see if I understood correctly. you are suggesting that I rewrite the whole program in C++, plus any additional library code I might be using, so that I can use the widgets. does not sound as very practical advice to me.. > -Original Message- > From: Guru Kathiresan

RE: [sqlite] ANN: Sqlite3Explorer

I found the offending call and removed it. it was *not* in the devExpress code, but the visual query builder code. as a result, table captions are no longer "nice"... pls download again. > -Original Message- > From: Serge Liber [mailto:[EMAIL PROTECTED] > Sent: Monday, April 04, 2005

答复: 4p84: [sqlite] Sqlite causes exit error under symbian!

Thanks for your reply I have changed my code as below: > > > sqlite *db; > > > char *zErrMsg = 0; > > > db = sqlite_open("test.db", 0, ); > > > sqlite_close(db); > > > db = NULL; Now I am sure that zErrMsg is NULL after sqlite_open(),and I don't get the "-DOS_UNIX" in my complier , btw ,I use vc6

Re: ´ð¸´: [sqlite] Sqlite causes exit error under symbian!

> I do have try your suggestion, but it seems to no effect :( > For Symbian OS it is very strict with the memory assignation, u must call > closeSTDLIB() after using some stdlib functions otherwise u will got the > exit error. > So I guess my issue like that But I have no idea about what to

答复: [sqlite] Sqlite causes exit error under symbian!

Thanks for reply! I do have try your suggestion, but it seems to no effect :( For Symbian OS it is very strict with the memory assignation, u must call closeSTDLIB() after using some stdlib functions otherwise u will got the exit error. So I guess my issue like that But I have no idea about what

Re: [sqlite] Sqlite causes exit error under symbian!

On April 4, 2005 11:58 pm, Dan Kennedy wrote: > --- StevenLiu <[EMAIL PROTECTED]> wrote: > > here is my code : > > > > sqlite *db; > > char *zErrMsg = 0; > > db = sqlite_open("test.db", 0, ); > > sqlite_close(db); > > db = NULL; > > delete db; > > ^ > > Maybe leave that bit out. That's