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.