hi all,
I got something like this:
var
dbConn: TSQLite3Connection;
trans: TSQLTransaction;
query: TSQLQuery;
procedure NewBox(sn:integer;name:string);
var
cc:integer=0;
begin
query.Close;
query.SQL.Text :='insert into box(sn,name) values(' +sn.ToString + ',"' + Name + '")';
query.ExecSQL;
cc := query.ChangeCount;
trans.Commit;
query.Close;
end;
After NewBox is called, with database browser I can see the new record is added into the table "box". But I always got cc as 0. why?
ps: I tried with mysql5.7 and sqlite3, with both of these 2 database type, I always got cc as 0.