RE: Position To in a display file pgm using embedded sql

Phil,
My experience with this, is that once they do a position to, they are stuck
looking at the records below the pos to.   If they want to go back up, then
they need to do another pos to to get to the desired records.
I'm open to suggestions, if anyone knows how to do what phil has asked.

Phil
i have a working program, if you need an example
mike_smith@rgcresources.com

-----Original Message-----
From: Phil [mailto:sublime78ska@yahoo.com]
Sent: Tuesday, October 23, 2001 11:49 PM
To: rpg400-l@midrange.com
Subject: Position To in a display file pgm using embedded sql


Using embedded sql in a display file pgm, how should you handle "position
to"?

I am thinking of "select field, field2, etc where PositionToField >= value".

But what if the user then presses page up?

I don't want to do a fetch next through the entire cursor.  That could take
a long time.

Thanks for your input,

Phil



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.