Re: Numeric fields in 4gl 7.20

On Mon, 1 Feb 1999, Sinan UST wrote: > FYI. > > 4GL 7.20 does not allow a numeric field to match with space (''). > Eg. qty is a numeric field : > > select qty from table_a > where qty != ''> > Although this query works fine in 4GL 4.12, it returns -201 sql > syntax error in 4GL 7.20. > > Further information will be appretiately accepted. Is this a compile-time error or a run-time error? I'd suspect it is a run-time error. The problem will then be that the engines have been upgraded to reject what was always a dubious condition given that qty is a numeric type and not a character string (presumably the test should be IS NOT NULL). If it is a compile-time error instead, then the I4GL compiler has been tightened up to reject what was always dubious. Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn