Hariyanto <[EMAIL PROTECTED]> wrote:
I have 2 table:1. Table A : no INTEGER PRIMARY KEY, name varchar(15); 2. Table B : no smallint, (Foreign key) Address varchar(20); Telp varchar(10); Usually I use this step when I save data : - insert A (name) VALUES ("Mr.X"); - x = Select no_id FROM A where name = 'Mr.X' - Insert B (no_id, Alamat, Telp) VALUES (x, 'xxxxx', '123');
Can't you use sqlite3_last_insert_rowid API? Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
