[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Data validation via subroutine (OpenInsight 32-bit Specific) ====
=== At 17 NOV 2003 12:26:06PM Warren wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
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.
</QUOTE>
----

=== At 17 NOV 2003 12:26PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>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.

</QUOTE>

----

=== At 17 NOV 2003 12:26PM Jeff Morra wrote:  ===

<QUOTE>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?

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=BAFA0610E24B372E85256DE1005FC656|View this thread on the  forum...]]