Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete certain fields from table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Photos et traitement d'images
Divers
Thread ID:
00367412
Message ID:
00367414
Vues:
29
If you have SET EXACT OFF, placing an empty string on the right of an expression will return .T. for any character expression on the left, so this is not a good way to do this. Try using the EMPTY() function:

If EMPT(MyFirstTable.ItemName) then...

HTH!
Mark


>I am new to Visual FoxPro. I would like to delete fields from a table I am using. How would you go about deleting a field based off of certain criteria? I run this code in the init of my listbox when form first loads.
>
>*If name of field is not entered then delete this blank record
>If MyFirstTable.ItemName = "" then
> *Delete blank record
> DELETE
> *Skip to next record
> SKIP
> *Check to make sure we are on valid record
> IF EOF() THEN GO BOTTOM
>ENDIF
>
>Sometimes this code deletes what I would consider valid records. Is there anything else I could try to get this to work?
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform