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 So, I guess the behavior has not changed for c-version apprarently. HTH ____________ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. 226 Westchester Ave | Office : (914) 681 3296 White Plains, NY 10604 | Fax : (914) 682 5236