delete a record (syntax)

[KingSlick]

Ok, I have a .dbf that I would like to delete some records out of it. The problem is that I need for it to remove based on several different strings that appear in the different fields.

I have the following below that keeps giving me errors...

delete for LOWER(laSortingOrder[zz,1]) $ LOWER(source) AND LOWER(laSortingOrder[zz,3]) $ LOWER(source) AND NOT LOWER(laSortingOrder[zz,1]) $LOWER(source)

any help would be great. Thanks in advance

 

[dgrewe]

Markros, Olaf
I was trying to troubleshoot what could have been wrong & to find the error.
I know the 3 delete commands is the exact same as the one posted. I was trying to Isolate the error to a specific part of the command.


David W. Grewe Dave

 

[markros]

In my mind, these two commands

delete for LOWER(laSortingOrder[zz,1]) $ LOWER(source)

delete for NOT LOWER(laSortingOrder[zz,1]) + "0]" $ LOWER(source)

contradict one another. Once you deleted everything which has LOWER(laSortingOrder[zz,1]) in the Source, I can not figure out what the last command is supposed to do.

 

[KingSlick]

Ok everyone, there was no error in the syntax. I failed to scroll the screen over to the and notice that I had actually put an into table at the end of the line. Once that had been removed then everything was fine.

Thanks for every ones help.

 

[markros]

It's good that the problem is solved, but I think that you can not substitute your original statement with 3 different delete statements as was suggested.

 

[Olaf Doschke]

no, Dave just split the deletes to find the offending expression. To do that I'd rather would have suggested to just Evaluate or print these expressions, eg if a statement like

IF exp1 OR exp2 AND exp3

fails you can of course simply test
? exp1
? exp2
? exp3

It's a general strategy to cut something to smaller portions, not just only for debugging.

Bye, Olaf.

 

[markros]

I agree, the point is, that doing 3 separate commands will result in (FirstCond And SecondCond and ThirdCond), not in OR. In this particular case FirstCond eliminates the third condition, or so it seems.

 

[NasibKalsi]

Markos you are right. The only way to have some result may be to revese the order i.e. first statement to execute at last. But still will not accomplish what the user wants.
It is just a pointer to the user to find where the problem is.

Nasib Kalsi