Re: Strange behaviour of FOREACH (INFORMIX-4GL Version 7.30.HC4P1)

Hi,

Update on this problem posted by me:

While reading from the table 'tab1', after some processing, we also
update one timestamp field in the same table 'tab1'. So in short the
program is something like this:

FOREACH cur1
...
<Do some processing here>
...
EXECUTE upd_stmnt_for_tab1
END FOREACH

Regards,
Ravi.

Fernando Nunes wrote:
> 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.

.

Relevant Pages

  • Re: Strange behaviour of FOREACH (INFORMIX-4GL Version 7.30.HC4P1)
    ... it may be a bug in the server, ... Ravi wrote: ... > cursor, it is not returning all the rows which satisfy the conditions. ... > some kind of bug in Informix 4GL tool for the version mentioned above. ...
    (comp.databases.informix)
  • Re: New doc starts on top edge of page?
    ... Thanks very much Jay - yet another tick box I hadn't noticed! ... Regards, ... >>I notice that when copying text from the web into Word for reformatting ... >>the cursor moves down to the proper position. ...
    (microsoft.public.word.application.errors)
  • Re: Getting values from the plots
    ... the rangefrompoint came about because it was used to grab the ... range from underneath the cursor point. ... Regards, ... >> The Microsoft Office Web Components Black Book with .NET ...
    (microsoft.public.office.developer.web.components)
  • Re: Help, why my usb host support usb mouse, but the mouse cursor doesnt be showed?
    ... Thank you very much, I have add this catolog, but the mouse cursor ... Best Regards ... that support hard-cursor ... lost some necessary catalog, please help to know what catalog I must add ...
    (microsoft.public.windowsce.platbuilder)
  • Re: Getting values from the plots
    ... have a look at the rangefrompoint method, ... Regards, ... > I need to create a graph control that allows me to plot the graph from an ... > mouse up and mouse down to get the cursor positions on the graph. ...
    (microsoft.public.office.developer.web.components)
Loading