Hello,
I try to move a mysql database to sqlite3.
As the project is not that big, I move one table at the time.
I am using zeos for the mysql database.
Zeos: connection, table and datasource.
Sqlite: connection and datasource.
I try to write this:
procedure TForm1.Button1Click(Sender: TObject);
var countrecord: longint; recordnumber: longint;
begin
countrecord:= Ztable1.RecordCount;
Button1.Caption:= inttostr (countrecord);
for recordnumber:=0 to (countrecord - 1) do
begin
ZTable1.RecNo:= recordnumber;
Sqlite3Dataset1.Insert;
Sqlite3Dataset1.IndexFields[0].AsString:=ZTable1.FieldByName('Nogle').AsString;
Sqlite3Dataset1.Post;
end
end;
All that I got is an exception class:
External SIGSEGV
I am aware that the code is not the best, but it's compile fine.
Can you please tell me where I should look?
Thank you
Best Regards
Jean-Christophe