Re: [sqlite] Setting Autoincrement

At 11:01 PM -0700 4/5/04, Keith Herold wrote: I have an in-memory db that periodically writes to a disk db (there are good reasons for this). Later, I may need a connection to that disk db via another memory db, but any inserts from that connection need to take place at the appropriate autoincreme

RE: [sqlite] SQLite and ODBC/JDBC driver

> -Original Message- > From: Jean-Eric Cuendet [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 6:06 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] SQLite and ODBC/JDBC driver > > There is an ODBC driver here: http://www.ch-werner.de/sqliteodbc/ > But there is no client/se

Re: [sqlite] How to use last_insert_rowid()?

>From: "Rob Duncan" <[EMAIL PROTECTED]> >The last_insert_rowid() function seems to be close to what I want. The >trouble with it is that as soon as I add a row to the first child table >its value will change and I will not be able to use it for any other >child inserts. Hi Ron, SQLite doesn't su

[sqlite] SQLite and ODBC/JDBC driver

Hi, I would like to embed SQLite in our application and access to it from another one, through either ODBC or JDBC. Any idea? There is an ODBC driver here: http://www.ch-werner.de/sqliteodbc/ But there is no client/server, the server is embedded in the ODBC driver on the client. I think that we

Re: [sqlite] How to use last_insert_rowid()?

Here are 2 tables to use in our example: CREATE TABLE t1 ( t1_pk INTEGER PRIMARY KEY, t1_value VARCHAR(20) ); CREATE TABLE t2 ( t1_fk INTEGER, t2_id INTEGER, t2_value VARCHAR(20) ); t1_pk would be the primary key on your main table (t1), t1_fk would be foreign key to t1_pk an

Fw: [sqlite] Setting Autoincrement

Hi, I think you should insert the real value you need (516, 517,etc...) instead of NULL. sqlite autoincrement means if NULL inserted it checks the last value and inserts the next. I hope it will help. - Original Message - From: "Keith Herold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se