Thanks for replying,

So essentially overwrite the pfc_update and depending on the action that was going to take place write my own insert or update code?

Hi David,

I would try overriding the pfc_update() event of the DW control. Insert your own embedded SQL in that event, and return 1 if the update succeeds and -1 if it fails (assuming you are allowing the pfc to handle your transaction processing).

Understood, thanks Chris.

Hi John, thanks for replying.

I have a legacy app that makes fairly extensive use of sqlpreview. We are migrating this application to PB2022 R3 for deployment to PowerServer. This version of PowerBuilder does not fully support sqlpreview, just the select portion of it.

I am trying to figure out how to modify our application so I can intercept the update statement and perform my own processing with data that is sitting in the dw control. Not really sure where to start or how to do this. I am very familiar with PB but not PFC or sqlpreview.

Any advice would be appreciated, thank you.

Hi, David -

The statements in your question are confusing. SQLPreview is a DataWindow control's (DWC's) event that is triggered as a result of the DWC's Update method, not "before they [the SQL statements] are executed against the DataWindow". The DW already contains the new data that WILL be inserted into the database table, and SQLPreview lets you inspect the SQL statements before they are sent to the database, modify them or have them skipped (not sent to the database).

It's difficult to advise you without a clearer understanding of what you are needing to accomplish. Could you please provide an overview with enough details so that myself and others can advise you properly?

Best regards, John