Re: Informix Bug or valid SQL?

Daniel Wright wrote: > > I believe this is an Informix bug, especially since older versions used > to give an SQL error when you Declared a cursor selecting X columns, but > used a fetch with Y columns (where X != Y). I've NEVER seen this give an error, only a warning. That's just in versions 1-6. :-) > V7.21 and 5.something or other let you do this (I wrote test cases in > both 4GL and ESQL/C) That's right. > Does everyone else agree that this is a bug (not only in the code I > tested, but in Informix itself for returning a SQLCODE of zero)? No. It has always been a warning only. You should look at SQLCA.SQLAWARN[4]. If this is set to "W" then the number of items in the SELECT is not the same as the number of program variables. It will however return what it can. > God, I wish I could bill that time wasted due to this to Informix. Well you can't now. ;-) Cheers, -- 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! | +------------------------+-----------------------------------------+