Convert Checkbox value to "Y" or "N" during WRITE (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== Convert Checkbox value to "Y" or "N" during WRITE (OpenInsight 32-bit Specific) ====
=== At 18 MAY 2002 07:08:28AM Rudhy B wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
I am running both Arev and OI32 to access the same data.

There is a field that contains the value "Y" or "N" in Arev. However, in OI forms, I would like to convert this field to a check box and write back the result to "Y" or "N"



In the READ event, i wrote:

if {PREMI} EQ "Y" THEN

	set_property(win_name : ".PREMI","CHECK",1)

END ELSE

	set_property(win_name : ".PREMI",0)

END



The above works well. But during the WRITE event, I want to change the value back to "Y" or "N" (i don't want to save it as 1 or 0)



So i have the following script at WRITE event:

CHECK_STATUS=GET_PROPERTY(WIN_NAME : ".PREMI","CHECK")

OPEN "DICT.EMPLOYEE_DB" TO @DICT ELSE NULL

IF CHECK_STATUS=1 THEN

     {PREMI}=Y"

END ELSE

     {PREMI}=N"

END

FORWARD_EVENT()

RETURN 0



But it always write back as 1 or 0. I tried changing the @record but it still writes back as 1 or 0 (instead of Y or N).



What should I do ?



Rudhy
</QUOTE>
----

=== At 18 MAY 2002 10:05AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>{} is pure RHS and cannot be used LHS, so={} is allowed but {}=is not.



The simplest solution we can see is to add a hidden field containing the data (Y or N) and a non data linked check box. At the pre-save if the check box is true set the data aware control to Y, if false N.



[url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]

[url=http://www.sprezzatura.com/cebit.htm" onMouseOver=window.status= Celebrate CeBIT with GREAT offers on consultancy, programming and training';return(true)][i]Celebrate CeBIT with Sprezz Local![/i][/url]

[img]http://www.sprezzatura.com/bitzz.gif[/img]

</QUOTE>

----

=== At 18 MAY 2002 04:51PM Richard Hunt wrote:  ===

<QUOTE>You could also create your own "yes/no" ICONV/OCONV conversion proceedure. That way it would automatically do it for you at read and write time.



Check out the "ZIP_FORMAT" row (record), in the "SYSPROCS" table (file).



I use this method for comboboxes, checkboxes, and radio buttons. Works great.

</QUOTE>

----

=== At 19 MAY 2002 09:18AM Rudhy B wrote:  ===

<QUOTE>Yeap, that works :)

BTW, I love your CPUPlus and SList 32.



Rudhy

</QUOTE>

----

=== At 19 MAY 2002 12:05PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Very glad to hear it (and thanks ). Richard's answer is actually [i]better[/i] but figured ease of use would triumph over programming effort...



Sorry we missed you on way to Oz - can we catch you on way back? - Francesca has Singapore on her "must visit list". 



[url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]

[url=http://www.sprezzatura.com/cebit.htm" onMouseOver=window.status= Celebrate CeBIT with GREAT offers on consultancy, programming and training';return(true)][i]Celebrate CeBIT with Sprezz Local![/i][/url]

[img]http://www.sprezzatura.com/bitzz.gif[/img]

</QUOTE>

----

=== At 21 MAY 2002 06:26AM Rudhy B wrote:  ===

<QUOTE>I'll figure out Richard's way. But since I'm a OI novice i'll use ur solution for now:)



Francesca should stop over in Singapore (the cleanest city on earth :)



I'm in HongKong on the way to Manila. I'll be at the Las Vegas conference. I'll stop by introduce myself. I'm looking for tools to make it easier for us to convert our Arev app to OI.



Rudhy

</QUOTE>

----

=== At 21 MAY 2002 11:33AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>We do have tools to assist the process, as do other developers who hang around here! Look forward to seeing you at Vegas.



[url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]

[url=http://www.sprezzatura.com/cebit.htm" onMouseOver=window.status= Celebrate CeBIT with GREAT offers on consultancy, programming and training';return(true)][i]Celebrate CeBIT with Sprezz Local![/i][/url]

[img]http://www.sprezzatura.com/bitzz.gif[/img]

</QUOTE>


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