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
>