Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is out of range
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01370902
Message ID:
01371593
Views:
27
Hi Gerard

Why not use:
If not EOF()
    Skip
Endif
What's a "filrer" BTW?

>Hi Folk..thanks for your replies
>I am trying to narrow down possible causes of the problem and have set up a test
> re skip and eof.
>If I skip and a table is at eof() I get an 'End of file encountered ' error message rather than a record
> is out of range.
>
>Has this been your experience or do you know if there are conditons which will
> cause Record out of range with a skip beyond end of file ??
>
>In my partticlar screen, there are lots of Do while not eof() but only one GOTO, so if
> there is a possibility that Skip causes the error message(Record is out of range)
> there are a lot more places I need to home in on
>
>I have no relationships set, so this can be ruled out
>I dont think Indexes are out of sync so this can be riled out.
>I do have a filrer being switched on and off ...suspect thayt this may be contributing to it
>
>Regards,
>Gerard
>
>
>
>>In my experience, Record out of range can come from:
>> Do While !eof() loops when something causes the record pointer to go eof, then the skip is issued.
>> Indexes being out of synch
>> having a relationship set up and there is no corresponding record in the child table and you try to read data from the child record
>> issuing a GO TO RecNum and RecNum doesn't exist or has been deleted and deleted() is set on
>>
>>>Hi.
>>>I am getting a record is out of range, intermittently, in an app
>>>Even though I have error logging, it does not seem to be reporting the exact line the error is happening.
>>>Am I right in saying that this error is always the result of a GOTO record (or EDIT record) , or are there any other
>>>commands that can tigger this error message
>>>(If it is always the result of a goto/EDit , At least I can narrow down the possibilities)
>>>
>>>Thanks in advance
>>>Gerard
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform