Schultz’s PowerBuilder Notes

Dot Notation (Direct Access)


Dot notation for updating DataWindow properties first appeared in PowerBuilder 5. Before this time, programmers could only use Modify( ) and Describe to update DataWindow properties.

Continue reading

Advertisements

May 25, 2008 Posted by | Datawindow PowerScript | , , , , , , , , , , | 3 Comments

Event Sequences


Retrieve()

May 17, 2008 Posted by | DataWindow Control | , , , , , , , , , , , | Leave a comment

Where Clause for Update/Delete


Key Columns

This option is commonly used for single-user applications. It’s also used when working with “many-to-many” tables where the primary key consists of all the columns in the table

Key and Updateable Columns

This method provides maximum consistency

Key and Modified Columns

This option provides maximum concurrency

You should check the data model to make sure the update does not violate the business rules of the database. The value you are changing may depend on the value of another column that may have been changed.

May 9, 2008 Posted by | 2. Datawindows, Datawindow Painter | , , , , , , | Leave a comment