Need leading zeros (OpenInsight 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]]


==== Need leading zeros (OpenInsight Specific) ====
=== At 24 MAR 1998 09:09:11PM Dsig  (SigSolutions) wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am sure that this must have been hit before but looks new to me.



Some SIC (standard industry codes) begin with '0'.  But OI does not seem to like that.  The POPUP displays correctly but then when returned OI truncs off the leading '0's.



Any ideas how to keep this from happening?



(I have posted this on cis also)



dsig

David Tod Sigafoos ~ SigSoltuions

dsig@teleport.com  cis: 70302,77  voice: 503-639-8080
</QUOTE>
----

=== At 25 MAR 1998 12:26PM Russell Stokley wrote:  ===

<QUOTE>Is your datatype set to INTEGER?  Try VARCHAR instead.  I've been bitten by this when using Social Security numbers as an ID.

</QUOTE>

----

=== At 30 MAR 1998 12:22PM Cameron Revelation wrote:  ===

<QUOTE>dsig,



[i]Some SIC (standard industry codes) begin with '0'. But OI does not seem to like that. The POPUP displays correctly but then when returned OI truncs off the leading '0's.[/i]



I don't understand the question.  If my popup contains zero-fronted data, it returns it fine into a control on my form.  Perhaps the control has formatting (iconv/oconv) on it ....



Cameron Purdy

info@revelation.com

</QUOTE>


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