RE: Integer checks

Posted in 2008

Everett Mills — Tue, 16 Sep 2008 14:08:13 -0500 — source: Usenet: comp.databases.informix

> -----Original Message----- > From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] > Sent: Tuesday, September 16, 2008 2:02 PM > To: Everett Mills > Cc: informix-list > Subject: Re: Integer checks > > Everett Mills wrote: Snip > > > > LET char_time = in_time USING "&&&&" > > > > Will crash if time is greater than 9999 ;o) > > -- > Cheers, > Obnoxio the Clown > > http://obotheclown.blogspot.com > I noticed that right after I hit send. --EEM > > >

↪ replying to Everett Mills

Ian Michael Gumby — Tue, 16 Sep 2008 13:56:49 -0700 (PDT) — source: Usenet: comp.databases.informix

On Sep 16, 2:08 pm, "Everett Mills" <eemi...@nationalbeef.com> wrote: > > -----Original Message----- > > From: Obnoxio The Clown [mailto:obno...@serendipita.com] > > Sent: Tuesday, September 16, 2008 2:02 PM > > To: Everett Mills > > Cc: informix-list > > Subject: Re: Integer checks > > > Everett Mills wrote: > > Snip > > > > > > LET char_time = in_time USING "&&&&" > > > Will crash if time is greater than 9999 ;o) > > > -- > > Cheers, > > Obnoxio the Clown > > >http://obotheclown.blogspot.com > > I noticed that right after I hit send. > > --EEM > > I think the problem is reversed. I think he wants to store the value as an integer and use 4GL as a way to get an appropriate value in. So if your form has a date time (hour to minute) field, and then you take the value, format it in to an "hhmm" string and then convert to an integer, you should be ok. (Assuming that the conversion handles the leading zero.) Now wasn't this question asked and answered earlier?

↪ replying to Ian Michael Gumby

Obnoxio The Clown — Tue, 16 Sep 2008 22:04:27 +0100 — source: Usenet: comp.databases.informix

Ian Michael Gumby wrote: > I think the problem is reversed. I think he wants to store the value > as an integer and use 4GL as a way to get an appropriate value in. > Reading is fundamental. -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

↪ replying to Everett Mills

monkeys paw — Tue, 16 Sep 2008 20:53:04 -0400 — source: Usenet: comp.databases.informix

Thanks all, i combined both ideas in the end, much appreciated. > >> -----Original Message----- >> From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] >> Sent: Tuesday, September 16, 2008 2:02 PM >> To: Everett Mills >> Cc: informix-list >> Subject: Re: Integer checks >> >> Everett Mills wrote: > > Snip > >>> LET char_time = in_time USING "&&&&" >>> >> Will crash if time is greater than 9999 ;o) >> >> -- >> Cheers, >> Obnoxio the Clown >> >> http://obotheclown.blogspot.com >> > > I noticed that right after I hit send. > > --EEM >> >> >