{{tag>category:"OpenInsight 32-Bit" author:"Matthew Jones" author:"Barry Stevens"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Edittable %U% validation with output conversion (OpenInsight 32-Bit) ====
=== At 28 MAR 2007 10:30:19PM Matthew Jones wrote: ===
 
 
<QUOTE>
For an edittable column, the %U% unique multi-value validation fails if there is an output conversion nominated. I've tested a simple setting, ie Validation %U% and Conversion MD2,$ and the validation fails. The system seems to be checking the keyed input against the oconv'd data in other rows (ie iconv against oconv), rather than checking iconv against iconv or oconv against oconv. For example if I key in 123 on the first row, the system displays $123.00. If I then key in 123 on the second row, the validation fails (ie no message), but if I key in $123.00 on the second row, the validation works (ie system displays error message).

Obviously %U% is not a validation one would normally put on an MD2 field. I came across this on a column with my own user-conversion function which was not validating correctly so I simplified the testing back to just system functions.

Is this a confirmed OI bug or am I doing something wrong here?

If it is a problem, does anyone have a workaround?

Thanks,

Matthew Jones.
</QUOTE>
----

=== At 29 MAR 2007 03:36AM Barry Stevens wrote:  ===

<QUOTE>Try this in the poschanged script for the table.

I just palyed around with a single column table, so you will have to do a column test.





Pos=@CtrlEntId-]PrevSelPos

Value=get_property(CtrlEntId,"INVALUE",Pos)

foo=set_property(CtrlEntId,"INVALUE",Value,Pos)

call forward_event(Flag,FocusId)



RETURN 0

</QUOTE>

----

=== At 29 MAR 2007 09:52AM Matthew Jones wrote:  ===

<QUOTE>Thanks for that Barry, but I can't seem to get that to work.

It seems to be a mixture of events.

The forward_event looks more like a lostfocus than a poschanged.

The best I can do is a delayed action invalid message, that displays one cell behind where I am, if you know what I mean. Hmmm.

Still trying.

Matthew Jones.

</QUOTE>

----

=== At 29 MAR 2007 04:20PM Barry Stevens wrote:  ===

<QUOTE>]]The forward_event looks more like a lostfocus than a poschanged



Sorry, originally had it in gotfocus(dont ask )

But, it still worked in poschanged.

changed to:

call forward_event(NextColumn,NextRow)

I added more columns, still worked.

Unbound windows with 5 columns, 1st col had the i/o conversion, i=%U%, O=MD2,$ 

</QUOTE>


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