Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!cs.utexas.edu!wuarchive!waikato.ac.nz!comp.vuw.ac.nz!am.dsir.govt.nz!marcamd!mercury!fivegl!struan
From: struan@fivegl.co.nz (Struan Judd)
Newsgroups: comp.databases
Subject: A little (:-)) bug in INFORMIX (2.10.03K)
Keywords: OUCH decimal string conversion
Message-ID: <1991May9.024936.15884@fivegl.co.nz>
Date: 9 May 91 02:49:36 GMT
Sender: struan@fivegl.co.nz (Struan Judd)
Reply-To: struan@fivegl.co.nz (Struan Judd)
Followup-To: comp.databases
Organization: 5GL International Ltd, Auckland, New Zealand
Lines: 37

In the following program (shortened but complete 4gl) the stack
gets totally mucked up at the point shown :


    database <database>

    main
	define L_num integer, L_dec decimal, L_str char(1000)

	for L_num = 1 to 1000
	    let L_dec = L_num / 3.141
	    let L_str = L_dec { Things go haywire here }
	    message L_str, L_num
	end for
    end main


Additionally if the offending statement is changed to

	    let L_str = L_dec using "&&&&&&&.&&"

then every thing is alright.

This is primarily a problem for us because we have a 4gl code generator
    and we are unable to detect that a variable is a decimal as opposed
    to a string.

Has anyone else out there encountered this problem? found a way round it?
    or even got a bug patch from Informix themselves?

Please email responses

-- 
+------------------------------------------------+---------------------+
| Struan L. Judd                                 | struan@fivegl.co.nz |
| Of all the bit boxes in this electronic world, | PH:  +64 9 302-1621 |
| this message had to shift into this one.       | FAX: +64 9 302-1617 |