Hi Leo,
> insert into 'tblName' Values (NULL, 'five');
> create table 'tblRefMaxName' ('ref' integer, 'nn' text);
> insert into 'tblRefMaxName' Values (select max(id) from tblName,
> 'eins');
Apart from the responses already from other posters, you should use
the correct quotes for entities (table and columns names use double
quotes: ") versus literals (single quotes: '). So it should read:
insert into "tblName" values (null, 'five');
create table "tblRefMaxName" ("ref" integer, "nn" text);
insert into "tblRefMaxName" select max(id), 'eins' from tblName;
Tom
BareFeet
--
Comparison of SQLite GUI applications:
http://www.tandb.com.au/sqlite/compare/?ml
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
