Re: SQL FETCH

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
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Calendar - Get organized for the holidays!
> http://calendar.yahoo.com/
> +---
> | 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
> +---
>

+---
| 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
+---