I use ExecuteDirect method to insert a record in a SQLite3 SQL tabel. The
primary key is a sequential integer number. I have the follwoind contruction in
the moment I will execute the SQL Insert command:
try
cdsInventario.ExecuteDirect(auxstr);
except
On e:Exception do
begin;
Try ExecSQL
What is in auxstr?
What is your Table definition?
Since you are updating data using direct SQL, you will need to close
and re open the dataset so the dataset record is in sync
Luiz
2013/8/5 Arí Ricardo Ody ar...@gmx.com:
I use ExecuteDirect method to insert a record in a SQLite3
: [Lazarus] Error with TSQLite3Dataset?
Try ExecSQL What is in auxstr? What is your Table definition? Since you are
updating data using direct SQL, you will need to close and re open the dataset
so the dataset record is in sync Luiz 2013/8/5 Arí Ricardo Ody
ar...@gmx.com: I use ExecuteDirect