Table verify on controls (OpenInsight Specific)
At 08 JUN 1998 07:25:48PM Jeff Word wrote:
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.
At 12 JUN 1998 07:52AM Cameron Revelation wrote:
Jeff,
Could you provide some additional details? You have a validation against a table containing keys which are dates?
Cameron Purdy
Revelation Software
At 12 JUN 1998 11:52AM Jeff Word wrote:
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.
At 12 JUN 1998 01:17PM Cameron Revelation wrote:
Jeff,
I have forwarded your question to Gene. I am not sure which way it is supposed to work.
Cameron Purdy
Revelation Software
At 12 JUN 1998 01:35PM Gene Gleyzer wrote:
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
At 12 JUN 1998 02:43PM DSig (SigSOlutions) wrote:
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