-
Matt Balent
- PowerBuilder
- Friday, 25 July 2025 06:34 PM UTC
Ran into this issue when integrating Dynatrace metrics logging with our PB applications. The desire is to log start/end times for all SQL coming from the application; easy since it all goes through the transaction object sqlpreview event.
However, statements with the 'SELECT MAX(id) INTO :ll_maxid FROM ...' type format always return 0. This seems to be caused by ANY code/comment placed in the sqlpreview event of the Transaction object.
The behavior exists in PB2019 R3 and PB2022 R3 with connections to either SYBASE ASE (SYC Adaptive Server Enterprise driver) or MS SQL Server databases (MSOLESQL driver).
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.