Is it possible to limit the entry of this field to 15 characters?
If so, how?
Thanks
Column pre-validate script.
Any examples of what the script may look like would be greatly appreciated.
I searched the SageCity forums and didn't find any examples.
GetValue on the field.
Do an "if len(yourvariablename) > 15 then..." with a SetError when true.
Add the script as a "Pre-validate" on the column, and values longer than 15 characters will be rejected. (SetError + a "pre" script trigger mean things are blocked).
Edit... or do what Steve posted. Much more compact. I don't often think to use "value"...
In addition to the business logic validation, you could augment this with a UI script that physically restricts the control from accepting any additional characters.
Just create a Post-Load event on the pHeader and pHeaderW panels with the following logic.
retval = oUIObj.SetControlProperty("CustomerPONo", "Len", 15)
The logic above would still be required to restrict from the business object level accepting any data beyond 15 characters, in such areas like other BOI scripts, or Visual Integrator.
just food for thought....
Elliott
*Community Hub is the new name for Sage City