Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is out of range
Message
 
To
07/01/2009 09:01:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01370902
Message ID:
01371973
Views:
36
Hi Fabio
>CREATE CURSOR test (a i)
>GO 2
Yes. I understand this causes a Record Out Of Range

But I cannot get a Skip to cause a Record Out of Range Error ??

Regards,
Gerard


>>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