SQLPreview

Unsupported feature

The sqltype argument of the SQLPreview event only supports the PreviewSelect type, and does not support the PreviewInsert, PreviewDelete, and PreviewUpdate types. For the PreviewSelect type, PowerServer does not return the SELECT statement, the SELECT statement generated on the client side will be different from the SELECT statement executed in the database. The SELECT statement on the client side is generated according to the PowerBuilder logic, while the SELECT statement executed in the database is generated by the PowerServer runtime.

The request argument of the SQLPreview event only supports PreviewFunctionRetrieve, and does not support PreviewFunctionReselectRow and PreviewFunctionUpdate.

Workaround

N/A