Using in the validation of a control causes OI to verify that the value in that control exists in the table specified. However, it does not work for any control with a conversion on it. (dates for example) It returns a message that the value does not exist in the table.
Jeff,
Could you provide some additional details? You have a validation against a table containing keys which are dates?
Cameron Purdy
Revelation Software
We have a table with a two part key. One of the fields is a date that gets verified in another table that has a single part key of date. Using the convention to verify the date found in the first table, it does not seem to iconv the date before seeing if it exists in the second table. Therefore it says the item does not exist when in fact it does.
Jeff,
I have forwarded your question to Gene. I am not sure which way it is supposed to work.
Cameron Purdy
Revelation Software
Jeff,
For all types of validation/conversion, the FormIO logic first validates the user input (using in.value()) and then, if validation succeeds, converts it into internal format (using iconv())
The VERIFILE type of validation you are using is not an exception of the rule.
If you need it working differently I would recommend using a custom validation.
Gene
Jeff ..
as you can see your best bet is to write some code
If Xlate(tablename,Get_Property(CtrlEntId,Defprop$),"","X") Then
Call Forward_Event(...)End
dsig
David Tod Sigafoos ~ SigSOlutions
[email protected] cis:70302,77 voice:503-639-8080