Updates with Oracle (Views: 704)
|
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; |