Hi Ganesan,

I know this is not what you are asking, but is there a reason you are not using the "Stored Procedure Update" feature of the DataWindow itself? If you're not familiar with this, you access it in the DW painter under Rows > Stored Procedure Update...

You can specify which SP to call for insert, update, delete. If you don't specify a stored procedure for a particular SQL operation, that operation will be handled in the traditional way.

You do have to be sure that all arguments to the stored procedures are represented by either a column or computed column in the dwo, so you may need to add some dummy columns depending on your scenario.

With this technique, there's no need to visit the sqlpreview event.

Hi Julie,

Thanks for the response.

If it is few windows , definitely we can adapt the solution you have suggested.

But there are thousands of lines written in SQL Preview event across 50 to 75 windows. Hence it will be very difficult.

Thanks,

Ganesan R

Hi Ganesan,

Is it possible for you to change the code to the following way to work around SQLPreview unsupported feature?  Do you have any concern about this workaround?  If possible, please provide me a test case (send it to product@appeon.com).  I will ask our team to study about it.

long ll_row
DWItemStatus ldws_status

for ll_row = 1 to dw_1.rowcount() 
                ldws_status = dw_1.getitemstatus(ll_row,0,primary!)
                choose case ldws_status
                                case NewModified! 
                                               CALL an SP to insert record                                             
                                case DataModified!
                                                CALL an SP to update record
                                case else
                                                continue
                end choose
next

Best regards, Julie

Hi Ganesan;

  Unfortunately, these SQLPreview events are not supported in PS 2021 ... https://docs.appeon.com/ps2021/bk06ch02s01s05.html

Regards ... Chris