Re: Error -270 when having extra condition in where clause

: LET l_query =3D " : select code, sum(t_flaeche.flaeche) : from t_flur, t_flaeche : where : t_flur.onr =3D ? and : t_flur.nr_fmass =3D ? and : #t_flur.land_kz =3D ? and : t_flaeche.onr =3D t_flur.onr and : t_flaeche.nr_fmass =3D t_flur.nr_fmass and : t_flaeche.nr_flur =3D t_flur.lfdnr : group by code : order by code" : When i use the statement in this form (the land_kz condition not : active), i can open the cursor as much times i like and fetch data. : If i activate the extra condition and open the cursor for the second : time and make the first fetch, i got an error -270 (Cannot position : within temporary file). = Have you tried turning on SET EXPLAIN? I'll bet it takes different paths with the added condition. Have you tried checking for the ISAM error (in sqlca, I don't remember which field)? It should give you another error, something like "No disk space" or something like that. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.