How to update a DataWindow in PowerBuilder

[santosh2natal]

Hi all,
How to update a DataWindow in PowerBuilder at run-time of application, which is created using stored procedure itselt?

 

[mvanrijn]

Hi,

Set the update rows properties on datawindow. Allow Updates. Use key. Select all of the updateable columns. Select the key. Select use update. and make the table name a Junk name like"Junk".
In the sqlpreview event. Add the code to get all the values from your data window. and either update the db via sql or another stored proc

I hope this wasn't too confusing as I am doing this from memory.

Cheers
MJ