Commit on TOracleQuery or TOracleDataset - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access Commit on TOracleQuery or TOracleDataset

Print Thread

Commit on TOracleQuery or TOracleDataset #356 03/07/00 01:48 PM
Joined: Mar 2000 Posts: 8 Herdecke, NRW, Germany S Schlueter OP Member
OP Schlueter Member S Joined: Mar 2000 Posts: 8 Herdecke, NRW, Germany	I want to execute a UPDATE or INSERT statemant with TOracleQuery or TOracleDataset. But the records do not appear in the DB unless the program is terminated. What's wrong? Thanks in advance Rolf Schlueter

Re: Commit on TOracleQuery or TOracleDataset #357 03/09/00 05:25 PM
Joined: Nov 1999 Posts: 108 Bod Helene Member
Helene Member Joined: Nov 1999 Posts: 108 Bod	You need to call the OracleSession.Commit procedure in order to commit the changes in the database.

Re: Commit on TOracleQuery or TOracleDataset #358 03/10/00 01:49 AM
Joined: Oct 1999 Posts: 32 Sacramento, CA, USA A AndreyB Member
AndreyB Member A Joined: Oct 1999 Posts: 32 Sacramento, CA, USA	As well as set Dataset AutoCommit property to True

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 14 (0.006s) Memory: 2.5005 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-05-09 22:49:24 UTC
Valid HTML 5 and Valid CSS