Re: SQL FETCH

Phil, Dave,

  You can specify WITH NC to explicitly turn off commitment control.  Then 
you don't have to worry about remembering it on the compile.

  -mark

At 11/16/00 07:23 PM -0500, you wrote:
>Recompile the program with Commitment Control *NONE.
>
>That should do it,
>Dave
>
>----- Original Message -----
>From: "Phil Groschwitz" <sublime78ska@yahoo.com>
>To: <RPG400-L@midrange.com>
>Sent: Thursday, November 16, 2000 2:47 PM
>Subject: SQL FETCH
>
>
> > I have a display file pgm using embedded sql.  Has
> > been in place for months with no problems.  Now,
> > however, when a record is updated (like by another
> > user) and the first user updates the screen, which
> > does a FETCH FIRST, then clears the subfile, then
> > loads the subfile using FETCH NEXT, the changed record
> > reflects the original value.  Any added records are
> > not retrieved.  Only when the cursor is closed and
> > reopened does the correct data display.
> >
> > Any ideas?
> >
> > Thanks, Phil

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---