Re: problem with informix cursor

On Fri, 16 May 2003 09:48:49 -0400, ephesus wrote: > i found informix sometimes may miss some records in fectch cursor,could > someone tell > me why? > thx Version? Platform? Front-end tool? Troublesome SQL? Come on, you have to give us SOMETHING to work with here. If this is happening it would be a bug. There are several bugs in various versions which would cause an erroneous select set that would appear to be the cursor (implemented in the FE library) not returning some rows when it was actually the engine itself which had failed to return some data. Post your version/platform/tool info along with the specific query (and enough schema and data info to understand what's supposed to happen) along with specifics about what's "missing" and someone may recognize the problem Art S. Kagel