Ravi wrote:
> Hi All,
>
> We are facing a very strange issue while using FOREACH. The environment
> is as follows:
>
> HP-UX 11.11
> Informix 4GL 7.30.HC4P1
> Informix Dynamic Server Version 9.30.HC2
>
> 4GL program is opening a cursor on table 'tab1' with certain conditions
> in the where clause. When a FOREACH is applied to traverse through this
> cursor, it is not returning all the rows which satisfy the conditions.
> Due to this, the output of the program is not as expected. The
> behaviour is also not consistent as sometimes it gives 'x' number of
> records less and sometimes it gives 'y' number of records less.
>
> Please note:
> (1) The cursor declared is a plain cursor and not scroll cursor and
> without any WITH HOLD clause.
> (2) The isolation is set to dirty read before opening the cursor.
>
> Kindly let us know if there is any resolution to this issue. Is this
> some kind of bug in Informix 4GL tool for the version mentioned above.
>
> Thanks.
>
> Regards,
> Ravi.
>


And the contents of the table are not changing while your program runs?

Regards.