>My FPW 2.6 app opens 10-12 dbfs; 6 of them are RELATEd to each other. In debugging, I am finding when I suspend the program at certain places, the record pointers of the related databases seem to be "stuck" at the bottom. I can browse, but when I try to move to another record, the cursor returns to the last record. I can see them all, and when I check for a filter there is none. All SEEKS fail. This happens on the "lead" dbf, also, the one that the relationships hinge on.
>
>I know this is not always happening, because I SEEK the lead dbf constantly in the app and get results.
>
>Clues? What should I look for here?
>
>TIA
Tina
Your Fail is being componded (or cascaded) by a record not being found in a failed Seek. What I usually do is put in 'Wait Window message' commands to show me where & what the problem is if a Seek fails & eof() is reached. I would say trp the EOF() & handle it from there. Either loof for EOF() or use the SEEK() command.
HTH,
Tom