auto commit property?

[dragonstar]

I'm looking in the help file and it says both MyConnection and MyQuery are supposed to have an AutoCommit property.

They aren't listed in the object inspector and when I try and set them in code I get unknown identifier.

So which is right? There's is or isn't supposed to be such a property?

And if not where the help says, where is the mechanism for enabling auto commit for inserts, updates, deletes, etc.?


drc

[Dimon]

TMyConnection and TMyQuery components don't have the AutoCommit property. If you change data (e.g., insert, update, delete), it is saved in a database automaticly on calling the Post method, unless you use transactions. But if you execute the StartTransaction method, then to save data to a database, execute the Commit method.

[dragonstar]

Got it. But it'd be nice if the help was accurate, as in not mentioning properties that don't exist.

And what about a Query whose sql is an update statement? No Post method for that just Execute, anything else have to be called to get the changes to commit?


drc

[swierzbicki]

And what about a Query whose sql is an update statement? No Post method for that just Execute, anything else have to be called to get the changes to commit?

It's the same !
All modifications done to the database will be saved when commit method will be called (or cancelled if rollback method is called).

Exemple :

Code: Select all

MyConnection.StartTransaction;
Try
//....(update, insert delete anything you want)
MyConnection.Commit;
Except
//...an error occured, rolling back modifications
MyConnection.Rollback;
End;