SQL FETCH

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

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