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:

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

[email protected] cis: 70302,77 voice: 503-639-8080

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

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

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

dsig,

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 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

[email protected]

View this thread on the forum...