× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Just as a follow up for anyone who is interested. I used Lim and Ron's suggestion of of the do loop surrounding the EXFMT (and also the record retrieval logic). I took Reggie's suggestion of removing the ROLLUP/ROLLDOWN keywords (counter-intuitive but understandable given his explanation) which took care of the "missing" page phenomenon.

I changed a variable that was counting records so it was different than the variable that selected a record value for return and I set on LR,03 and 58 when a record was selected so the program would end.

Learned much, as usual, in the process.

Thanks for all the suggestions.

Pete


Pete Helgren wrote:

OK....My first instinct is not to rewrite this so I am following Lim and Ron's similar suggestions (a DO loop surrounding the EXFMT statement conditioned on F3/F12).

Here is what I found....

This works, almost. What I would want to have is a conditional on F3or F12 to exit the program but still have enter be the primary means of selecting a value and then ending the program. Right now, an F3 or F12 will return the selected value but that is counter intuitive (I think F3 or F12 should end the program and NOT return a value...only selecting a value and pressing enter should). In any case, it still doesn't work with selecting a value and pressing enter to return.

The second problem is more interesting. I have 24 records loaded in the subfile. Each page displays 10 entries but I never see a last page with 4 entries, it just displays the first 10 again. In other words I only see 20 records (2 pages of 10 entries) , never the last 4.

Perhaps I have to start from scratch to get this to work properly (your recommendations requested). The problem is that I have three other programs just like this that I'd also have to re-create if I started from scratch.

Parse other posts for the source....I'll re-post everything if that is more helpful.

Many thanks,

Pete


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.