From: BareFeetWare list....@barefeetware.com Sent: Thu, January 27, 2011 8:50:15 AM > >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);
Thank you. This is very convenient. And seems so obvious now that I have seen it. Not sure why I didn't figure this out on my own. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users