On 27/01/2011, at 3:30 AM, Jeff Archer wrote: > INSERT INTO [Microscopes] VALUES(@MicroscopeID, 'nSpec', 'default'); > > INSERT INTO [Objectives](ObjectiveID, MicroscopeID, TurretPos, Name, > Description, Magnification, NA, WD) VALUES( 1, @MicroscopeID, 0, '5X' , 'CFI > LU > Plan Fluor BD 5X' , 5.0, 0.15, 18.0);
If I understand your objective, I think you can just do it all in SQL, without having to re-injecting data an bind from your code: INSERT INTO "Microscopes" VALUES(null, 'nSpec', 'default'); create temp table "Store" (MicroscopeID); insert into "Store" select last_insert_rowid(); INSERT INTO "Objectives"(ObjectiveID, MicroscopeID, TurretPos, Name, Description, Magnification, NA, WD) VALUES( 1, (select MicroscopeID from Store), 0, '5X' , 'CFI LU Plan Fluor BD 5X' , 5.0, 0.15, 18.0); INSERT INTO "Objectives"(ObjectiveID, MicroscopeID, TurretPos, Name, Description, Magnification, NA, WD) VALUES( 2, (select MicroscopeID from Store), 1, '10X' , 'CFI LU Plan Fluor BD 10X' , 10.0, 0.30, 15.0); etc Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
