Jeff Archer wrote: > Are there any performance or other considerations of the order of the > fields for an insert?
No; what matters is the order of columns in the table. > INSERT INTO mytable(wid1,cnt,dat,wid3,wid2) VALUES (?,?,?,?) > - VS - > INSERT INTO mytable(wid1,wid2,wid3,cnt,dat) VALUES (?,?,?,?) Both statements will result in exactly the same error. ;-) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users