1. Ferdinand Fischer
  2. PowerBuilder
  3. Tuesday, 10 September 2019 17:29 PM UTC

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

 

Michael Kramer Accepted Answer Pending Moderation
  1. Tuesday, 10 September 2019 18:10 PM UTC
  2. PowerBuilder
  3. # 1

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.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 10 September 2019 18:48 PM UTC
  2. PowerBuilder
  3. # 2

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.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 10 September 2019 18:16 PM UTC
  2. PowerBuilder
  3. # 3

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.
  • Page :
  • 1


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