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
dsig@teleport.com 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
info@revelation.com