Re: Informix: Dumb decision guys!

* Kerry, * * ____________________________________U wrote _________________________ * * The following wee program illustrates that it's now perfectly reasonable * to select CHAR columns into SMALLINT fields without an error: * * main * define i smallint * * -- Point at a database (You'll want to change this line) * database stores6 * * -- Program should die if we have an error * whenever any error stop * * -- Clear out, and startup, the errorlog * run "rm -f dumb.log" * CALL startlog("dumb.log") * * -- Select a char column into a smallint * select tabname into i from systables where tabname = "systables" * * -- Look ma -- no problems! * display "nothing wrong, status = ", status * * -- But check out the errorlog... * display "but what's this?" * run "cat dumb.log" * * end main * * The above *might* be a bug, or it might be expected behaviour. * Waddaya reckon? (This with 6.02.UC1 RDS) * * _______________________________________________________________________ * * I ran the above program in my environment 6.02 UC2 c-compiled version * on DEC-Alpha. * The program bombs out in our case with the following message * * Program error at "c.4gl", line number 19. * FORMS statement error number -1213. * Character to numeric conversion error * * The log entry is :---- * Date: 04/05/1996 Time: 13:17:38 * Program error at "c.4gl", line number 19. * FORMS statement error number -1213. * Character to numeric conversion error It also works on our 6.01 RDS but fails on our 6.01 C-Code version. Thanks, ----------------------------------------------------------------------------- Robert Minter Data Systems Support Senior Software Engineer A Client Technologies Company E-Mail: rob@dssmktg.com Tel: 714.771.0454 #include <disclaimer.h> Fax: 714.771.3028 De Colores - Emmaus OC-13 http://www.dssny.com