Title: Updates with Oracle
Question: How can I commit the Updates with Oracle 8.0.6 and Delphi 5.0 ? I don't want to use a DBNavigator, but buttons.
Answer:
I would add a new TQuery component to your Databasa module. Call it CommitQuery. Edit the SQL property of CommitQuery by writing 'commit'; in the editor. And change the database alias so that the query will be posted in the right database. Create the ButtonOnClick procedure and add the line CommitQuery.Execute;
Or you can do something like this
Database1.startTransaction ;
try
Somequery.edit ;
// Do someting wityh the query.
Somequery.post ;
Database1.Commmit ;
except
Database1.Rollback
end;
end;