Insert problem with SQLite and D2010
Posted: 13.09.2013, 11:02
Hi people,
I am new here but have been using ZL for sereval years, mainly with PostgreSQL. Right now I start a new application which requiries using SQLite. I downloaded the lastest sqlite3.dll and put my comps on the project. Everything seems to work fine but the insert into.
The insert statement will not work, getting me a wierd problem on the table as it results of repeating the same data for all the fields! Select is working fine, delete not tested yet.
So, if I do: insert into mytable (id, name, addr) values (:id, :name:, :addr) and use a qry.ParamByName('name').AsString (or .Value) and set the addr parameter, none of that info will be saved, strangely the ID column value will replace all the fields.
Is there another right way to use ZL with Sqlite? I really need solve this asap.
Thank you everyone.
I am new here but have been using ZL for sereval years, mainly with PostgreSQL. Right now I start a new application which requiries using SQLite. I downloaded the lastest sqlite3.dll and put my comps on the project. Everything seems to work fine but the insert into.
The insert statement will not work, getting me a wierd problem on the table as it results of repeating the same data for all the fields! Select is working fine, delete not tested yet.
So, if I do: insert into mytable (id, name, addr) values (:id, :name:, :addr) and use a qry.ParamByName('name').AsString (or .Value) and set the addr parameter, none of that info will be saved, strangely the ID column value will replace all the fields.
Is there another right way to use ZL with Sqlite? I really need solve this asap.
Thank you everyone.