1. Ferdinand Fischer
  2. PowerBuilder
  3. Tuesday, 10 September 2019

Hi,

i wanted to log commits and looked at the sqlpreview event.

But it doesnt seem to be called by an commit - commit using tr; etc.

I dont know if that is a bug or if it is intended to be like this.

Does someone know?

 

Regards,

Ferdinand

 

Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Ferdinand;

   If you sub-class your own SQLCA (aka "descendant"), then you can then control the capture of these DML commands ...

Example (STD Framework) ...

Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
  1. Tuesday, 10 September 2019
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Ferdinand;

   Unfortunately, you are correct .. the "Commit" SQL command is not traced in the Transaction Object's SQLPreview event.

   This would need to be an enhancement request.

Regards ... Chris

Comment
There are no comments made yet.
  1. Tuesday, 10 September 2019
  2. PowerBuilder
  3. # 2
Michael Kramer Accepted Answer Pending Moderation
1
Votes
Undo

Hi Ferdinand, I believe it has been like this since transaction object got its own SQLPreview. I just tested with absolutely latest bits available and find same behavior remains.

Note: SQLPreview is silent to both COMMIT and ROLLBACK.

You may opt for dynamic SQL =

EXECUTE IMMEDIATE "COMMIT" USING SQLCA;

This fires SQLCA's SQLPreview with SQLFunc = SQLDBOthers! and SQLSyntax = "COMMIT"

I know not a favorable workaround. I would consider log it as feature request.

HTH /Michael

Comment
There are no comments made yet.
  1. Tuesday, 10 September 2019
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.