[SOLVED} Proper method to use

[dodgebros]

Is this the proper way to code using these components, in particular do I need to set DataModule1.SQLTransPlsizes.Active equal false after a commit?  SQLTransPlsizes is a TSQLTransaction component from the SQLdb tab.
TD
 

Code: [Select]

  DataModule1.SQLQryPlsizes.SQL.Text := "SELECT * FROM tblPlsizes";
  DataModule1.SQLTransPlsizes.Active := true;
  DataModule1.SQLQryPlsizes.ExecSQL;
  DataModule1.SQLTransPlsizes.Commit;
  DataModule1.SQLTransPlsizes.Active := false;


[cdbc]

Hi
TMK, "DataModule1.SQLTransPlsizes.Commit;" aswell as "DataModule1.SQLTransPlsizes.Rollback;" ends the transaction started with "DataModule1.SQLTransPlsizes.Active := true;"
So there's NO need for this: "DataModule1.SQLTransPlsizes.Active := false;"
HTH
Regards Benny

[Leledumbo]

in particular do I need to set DataModule1.SQLTransPlsizes.Active equal false after a commit?

No, Commit will deactivate it as well. CommitRetaining is available if you want to keep the transaction open. I suggest reading SqlDBHowto to clear the confusion about how the various DB components work together, such as when StartTransaction is required to be explicitly called and when it's not.

[dodgebros]

Thanks for thee reply's, I will indeed read the SqlDBHowTo.
TD