Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is out of range
Message
From
07/01/2009 09:01:14
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01370902
Message ID:
01371663
Views:
29
>Hi Terry.
>Sorry my bad spelling ..meant to say FILTER
>
>I have a Do while NOT Eof() which should do same thing.
>but.... does a SKIP cause a Record Out Of Range ?
>I can only get it to cause an End of File Encountered
>
>Regards,
>Gerard
>
>
CREATE CURSOR test (a i)
GO 2
>
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform