Paradox, TQuery, ExecSQL I lost all data on system crash. Help !
Posted on 2002-06-07
Hi, I am using only TQuery to insert a data. Here's the sample how i use it.
with TQuery.Create(nil) do
DatabaseName := 'MASTER';
SQL.Add('insert into maindbex (Name, Username, Password)');
SQL.Add('VALUES (:Name, :Username, :Password)');
ParamByName('Name').AsString := 'Cenk';
ParamByName('Username').AsString := 'MyUser';
ParamByName('Password').AsString := 'MyPAssword';
this code runs without any problems. If i close program and shutdown pc and reopen it, everything i added into database is there. But, if electric cuts or system crashes then everything i added is gone. If i closed program before system crash then no problem but if if it happens while my program runing then all data added by this procedure goes... I couldn't find a way to fix this. I don't want to use TUpdateObject. Can someone help me?