About   -   Contact   -   Purchase   -   Search   -   What's New

Enable/Disable Row/Columns based on Data Values
New to PowerBuilder 4 was the datawindow column attribute, "protect". This attribute allows you to easily enabled and disable input into a row/column combination.

This attribute is very useful when you only want the user to enter data in key column for new rows. If you right click over a column and select the attributes... menu option. Scroll the list to the protect attribute.

Enter the following code:
If( IsRowNew() 0, 1) )

Or from Powerscript you could code:

If your logic is very complicated and you want to use it to enable and disable multiple columns then create a computed column that returns a value depending on your logic, then based the expression for the protect attribute on the computed field value.


Top of Page

Legal Notice

Ken Howe 2011