Gabor Boros wrote: > SC:=DB.Prepare('INSERT INTO MYTABLE (ID, FIELD1) VALUES (NULL, > :IN_MYPARAM_1);'); > > SC.Bind_Variant_By_Name('IN_MYPARAM_1',1); <-- error Try: SC.Bind_Variant_By_Name(':IN_MYPARAM_1',1); I have run into this SQLite oddity more than once. Regards, Tobias _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa