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

 

[bborissov]

Did you have any index based on "source" field?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[Stella740pl]

What error message do you get?

And it seems that you want
LOWER(laSortingOrder[zz,1]) $ LOWER(source)
and
NOT LOWER(laSortingOrder[zz,1]) $ LOWER(source)
to be true at the same time?

 

[KingSlick]

sorry about that, the not should be

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

error message is:
Command contains unrecognized phrase/keywords

Thanks

 

[Stella740pl]

Are you showing the exact code that you have, as it appears in your program?

Can you please post an exact piece of code, with all the semicolons (if any), line breaks, and all other necessary info?

 

[markros]

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

Your delete command is wrong. You can not delete for LOWER(laSortingOrder[zz,1]) $ LOWER(source) and NOT LOWER(laSortingOrder[zz,1]) $ LOWER(source) in the same time.

Can you describe your criteria for deletion in English?

 

[Stella740pl]

markros,

See KingSlick's above post with the correction of the criteria.

 

[markros]

In other words:

"something" $ lower(order) and not "something0]" $ lower(order)

It should work, but I'm thinking, how to simplify this criterion.

 

[Olaf Doschke]

Delete For LOWER(laSortingOrder[zz,1]) $ LOWER(source) AND LOWER(laSortingOrder[zz,3]) $ LOWER(source) AND NOT LOWER(laSortingOrder[zz,1]) + "0]" $LOWER(source)

...compiles without errors. Seems you didn't copy & paste the code exactly as it is. Even the missing space after the last $ does work, at least in vfp9.

Bye, Olaf.

 

[Mike Lewis]

KingSlick,

I'm sorry if this is stating the obvious, but have you got a semi-colon at the end of the first two lines? These do not appear in the code you posted.

Without the semi-colons, the first line will give the error you described.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Olaf Doschke]

Hi Mike,

such things can of course be the reason, I do have that same error but I emtered and compiled this as a single line.

Bye, Olaf.

 

[Stella740pl]

Mike Lewis,

I think that the code posted here is not the exact code that is used. The criteria had operand "0]" missing, so the the code was probably edited for the post. That's why I asked KingSlick to post the exact code with all the punctuation. Missing semicolons or something to that effect was my first thought, too.

Olaf,

I tried it as a single line, too, and just substituted the field name Source by another field name from a real table I had open - no error. Then I created a test table, with a field named source - still no error. VFP6 here. I guess, we need to see the exact code, semicolons could be the problem.
Or, possibly, the contents of laSortingOrder array.

Mike Yearwood,

Single quote and double quote are string delimiters, too, but you can always use them inside the string if the string is surrounded by a pair of different delimiters.
Anyway, I tried, and compiler doesn't have a problem with "0]". Actually, I use an opposite of it for years, and it works.

I use it like this:

theList=["First Item","Second Item","Third Item"]
DELETE FOR INLIST(&theList)
SELECT item FROM Something WHERE item IN (&theList)

 

[dgrewe]

KingSlick
Could you run the following 3 lines of code on your data and tell us the results ?

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


David W. Grewe Dave

 

[KingSlick]

Actually I didn't scroll all the way over and there was "INTO TABLE" at the end of the line. Once removed, it worked fine. Thanks for all the help though

 

[Imaginecorp]

Actually I didn't scroll all the way over and there was "INTO TABLE" at the end of the line....

ROFLMAO

Sorry...

 

[KingSlick]

Please make me feel like more of an ass!!

Yes, I know, I can be an idiot

 

[Imaginecorp]

KingSlick:
I am sorry if I have offended you, it was Not my intention…
People here will go out of their way to help and this was probably the first time that a poster did not check the complete code…which kind of threw everybody into a loop… But, believe me I have done worse…Just thought it was hilarious…

 

[KingSlick]

Imaginecorp,

I wasn't offended, I found it rather funny also. Sorry if I made you think that.

 

[markros]

dgrewe, I think you meant SELECT instead of DELETE. Or at least you should preceed this with a backup warning

And the first delete command actually eliminates the third.

 

[Olaf Doschke]

Dave your three deletes would be like a single one with ORed conditions...

Okay glad the spook came to a unmythical explaination .

Bye, Olaf.