Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record out of range after Find?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00441552
Message ID:
00441691
Views:
11
Steve:

>
I do a search form and find the record I want as follows.

DO \master\search

When I leave the search form I do the following.

SEEKID = master.incident+master.patnum+master.patqty
SELECT master
SET ORDER TO TAG incident
SEEK SEEKID
mast_REC = recno()
THISFORM.Release

After I return to my find button in my main form I do.

GOTO mast_REC

But I get an error that says, "Record is out of range." and then if I IGNORE the error I get "EOF" message. I checked mast_REC in both places and it has a valid record number such as 4675 both in the search form and after I return from the search form inside of my Find button code.

I tried SELECT master before the GOTO mast_REC, but no help. What am I doing wrong? Thanks.
>

If your "incident" tag expression is just "master.incident", then the SEEK is not successful and thus RECNO() returns RECCOUNT() + 1. GOTO mast_REC raises an error because it is an invalid record.

Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform