Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate & Continue
Message
From
07/01/2009 13:14:57
 
 
To
07/01/2009 13:08:16
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01371809
Message ID:
01371815
Views:
11
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform