• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Validation on row exit

adeel

VIP Member
Hello there

I want to know how to validate the column on row exit in Grid.
example if users exit the row I want the field to be validate e.g no blank allow. Is this can be achieve within application or I have to do custom programming?

Thanks in advance.
 

peterbruce

Legendary Poster
Ad,

It depends on the definition/properties of the grid column. For example the column may be edited against the data dictionary rules and specifications. If there are data dictionary overrides that disable editing then validation would need be specifically programmed.
 

adeel

VIP Member
hmmmm,

What steps I need to take e.g I want workdate to not allow null/blank. what method I should use or steps?


Thanks
 

peterbruce

Legendary Poster
Ad,

Check to data dictionary specification for the data item you are using for the work date. If has the rules you need, then it will cause an error when the cell is exited. Otherwise you can use the overrides tab in the column properties and user the data dictionary overrides to set up the edit rule you need. Or in one of the "exited and changed' events (column or row) write code to check the vale and display an error if the value is not correct.
 

adeel

VIP Member
Thanks Peter for help!, good to know about edit rule,

I will use Set Grid Cell Error system function for my requirement and fire if value null etc.

Thanks
AD
 
Top