Problem with Internal Error

Path: emory!swrinde!cs.utexas.edu!tamsun!mtecv2!root From: cluis@mtecv2.mty.itesm.mx Newsgroups: comp.databases.informix Message-ID: <4860@mtecv2.mty.itesm.mx> Date: 20 Jan 92 18:21:00 GMT Sender: root@mtecv2.mty.itesm.mx Reply-To: cluis@mtecv2.mty.itesm.mx Hello World ! The reason for I'm write to this group is for comment an strange SQL error (internal error) displayed in my 4gl application. I create a cursor based on a SELECT clause and ORDER BY one of the fields I'm chossing (of course). After that, I get the fields selected via a FOREACH statement and almost reached the end of the cursor, an SQL error number -565 ( Informix version 4.00 running in a IBM RS-6000 Model 550 ) "Cannot read sorted rows" appears. The case is that my application is runned every week and nothing bad had appears. I had read the description of the error and the corrective action says : Contact the Informix Technical Support Departmen. I had check the /tmp directory a has sufficient space. Then it could be an internal error. If someone have comments please let me know it. Carlos Luis Castillo Direccion de Informatica Tecnologico de Monterrey Monterrey N.L , Mexico e-mail : cluis@mtecv2.mty.itesm.mx