Re: 4.10 RDS code fails when on a box running 4.11 RT & 5.01SE

106156.550@compuserve.com wrote: > > I'm getting a problem with some code created under a 4.10 4GL RDS > environment and sqlexec of same version. > When code is ported to a machine with 4.11 Runtime 4GL and > 5.01 Standard Engine, I'm getting a character to numeric conversion > error (#1213) during a foreach. The foreach is running a cursor > for a select into a record defined (locally) like the table it > refers to; therefore, one would assume the column causing the error > matched the variable it is being foreached into. > Why is this and is there a way round it? The tables on your dev machine and your prod machine don't match. You may have added or dropped a column on the dev box and forgot to implement the change in the prod database. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+