Updates with Oracle

Problem/Question/Abstract:

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;