Mega Code Archive

 

Categories / Delphi / ADO Database

 

Updates with Oracle

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;