Re: ERROR 565

TA Tuan wrote: > > Platform : informix SE 5.01 with windows client. > When droping a temporary table, a fetch on a previous opened holdling > cursor with clause ORDER BY return error -565. It seems that updating > the Informix SE dictionnary deletes temporary results due to the ORDER > BY clause . Strangely enough, I got this error today together with -101. You need to check the accompanying ISAM error. I had dropped and created a table after opening a select cursor. Then got this error on the fetch. So I moved the open after the drop and create and the error went away! Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Emailto: 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! | +------------------------+------------------------------------------------+