>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()))
ENDDO