Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete certain fields from table
Message
General information
Forum:
Visual FoxPro
Category:
Pictures and Image processing
Miscellaneous
Thread ID:
00367412
Message ID:
00367414
Views:
30
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform