I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile.
I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on the position to info, but I can't do that in SQL can I?
I know I can read all the subfile entries until I get to the entry I need, but I am wondering if this is really the only way to get to it? or I could refetch records from the start until I reach the entry I want.
II don't really want to load all entries to the subfile at startup - only one page at at time.
I can easily do a SELECT where data field >= Position to field, but then how do I do a pageup without having to do another SELECT statement? I would really want to be able to do FETCH PRIORS