Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate & Continue
Message
From
08/01/2009 10:08:58
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
To
07/01/2009 13:10:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01371809
Message ID:
01372041
Views:
12
Thanks to all for the responses.
In the end I managed to debug it all the way through and found some code which was closing the table and reopening it, this was messing up the continue.

Thanks again to everyone for their input.

Jon


>>Hi All,
>>
>>I'm having an issue where an error occurs on the continue statement after a locate call, something like:
>>
>>
>> LOCATE FOR (PI.pe_dtstart<>CTOD("") .AND. (PI.pe_leavedt=CTOD("") .OR. PI.pe_leavedt>=DATE()))
>>DO WHILE FOUND()
>>	* lots of processing 
>>  SELECT PI
>>  CONTINUE **** errors here 
>>ENDDO
>>
>>
>>One thing to add is that this is processing a view of a sql table.
>>
>>Now I know its something in the "lots of processing" part thats causing the issue but as yet I havent figured out what.
>>
>>When debugging I have made sure that:
>>the correct alias is selcted
>>the record pointer is sat on the same record
>>the same number of records are in the table
>>the filter on the table is the same
>>the order on the table is the same
>>
>>Basically I'm after any pointers as to what make a continue command fail, the error it brings back seems to be meaningless.
>>
>>Any pointers greatly appreaciated.
>>
>>Thanks
>>
>>Jon
>>
>>p.s. - oops I forgot my manners - happy new year to you all.
>
>this is not the answer, but why not:
>
>SCAN FOR (PI.pe_dtstart<>CTOD("") .AND. (PI.pe_leavedt=CTOD("") .OR. PI.pe_leavedt>=DATE()))
>	* lots of processing 
>ENDDO
>
Previous
Reply
Map
View

Click here to load this message in the networking platform