Anvil of Time
Nature Forges Everything on the Anvil of Time

PowerBuilder ‘Gotcha’ – dddw Edit Type

Be careful when you change the columns in a datawindow object referenced in another datawindow object when using the DropDownDatawindow Edit Type.  If you change the column name which is referenced in the DDDW Edit Type of another you won’t get a compile error when saving – but you will get runtime errors.  This happened to me and I was only able to find it via a database trace.

Something which helps in finding this type of error is to use an application transaction object (like the PFC n_tr) and put code in the sqlpreview event.  This allows you to break in the event and check out the syntax to help in identifying the troublesome dw object.

Updated March 2021

• PowerBuilder ‘Gotcha’ – Datawindow Find method,
• PowerBuilder – Move Frequently Chosen Items to Top of DropDownDataWindow,
• PowerBuilder – Type ahead style dropdown datawindow columns