Data validation via subroutine (OpenInsight 32-bit Specific)
At 17 NOV 2003 12:26:06PM Warren wrote:
Okay, I thought I posted this yesterday but it appears to have dropped into the Notes blackhole.
What's the equivalent to doing a @S subroutine,parameter@ for data validation in OI forms?
Putting the above @…@ in the validation property for a prompt results in a runtime message "Data Validation Error: the data validation enforced by the catalyst subroutine "S SUBROUTINE,parameter".
The subroutine is not getting called.
I take it there is a syntax change but it is not in the documentation or helps that I can uncover and the variations I tried don't work.
At 17 NOV 2003 12:26PM Don Miller - C3 Inc. wrote:
Problem is .. ain't no Catalyst to call so .. You can use a call which will call a subroutine. You'll have to handle the exception and error processing in the subroutine. It's worth looking in SYSPROCS at some of the UDC code (ZIP_FORMAT is an example) to see what you have to do.
Don M.
At 17 NOV 2003 12:26PM Jeff Morra wrote:
I was trying to figure this out myself, and took a look at PHONE_FORMAT and ZIP_FORMAT and got a feel for what I have to do. I am basically doing it now in one output, but I am having a problem retreiving the original data before it got converted. For example, I have a dialog box that when someone puts a SSN into a field, I made a validation that reads a cross index to find out if it's a valid employee, then gets the key to the employee record, which it puts into TEXT. Now my output takes that key, reads the employees record and I want to display his name and some other info. Now when the coversion happens, the output changes my TEXT property, but I can't figure out how to get it to store they key. Any ideas?