Is at least one of the fields in the LOCATE is nullable? If so, then you may have a record in your view that have a NULL value in one of those fields. You will need to check that the field isn't NULL before checking the value.
HTH
>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.