Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locate & Continue
Message
De
07/01/2009 13:14:57
 
 
À
07/01/2009 13:08:16
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01371809
Message ID:
01371815
Vues:
13
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform