Deleting a record in a .db database

Hi,

I am writing records from a .db database to sql database.
What i am trying to do now, is i am reading certain fields from the sql database and in return i am trying to delete a record on my machine in delphi.

This was the code i was trying to use, but gives and error, but doesn't specify what is wrong
EliteDB.Execute "DELETE * FROM Batch_de where " & """" & "Batch Number" & """" & " = " & WBBatchNumber & ""

Can someone help with this, please!
mscalaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

watyCommented:
EliteDB.Execute "DELETE * FROM Batch_de where " & """" & "Batch Number" & """" & " = " & WBBatchNumber & ""

Could you post a sample query?

It seems that you query will be something like
DELETE * FROM Batch_de where "Batch Number" = AZER

You code should be this
EliteDB.Execute "DELETE * FROM Batch_de where Batch Number = """ & WBBatchNumber & """"

or
EliteDB.Execute "DELETE * FROM Batch_de where Batch Number = " & WBBatchNumber

if WBBatchNumber is a numeric
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mscalaAuthor Commented:
This is the code i am running
I tried something different, but still doesn't work

SqlWriteBatch = "DELETE * FROM Batch_de where " & """" & "Batch Number" & """" & " = " & WBBatchNumber & ""
                        RsWriteBatch.Open SqlWriteBatch, EliteDB, adOpenStatic, adLockOptimistic, adCmdText
EliteDB.Execute SqlWriteBatch

Your two statements, give the error "syntax error (missing operator)in query expression BatchNo = 1

???

0
Éric MoreauSenior .Net ConsultantCommented:
Give this a try (the * is removed and the field name is between square brackets):

EliteDB.Execute "DELETE FROM Batch_de where [Batch Number] = " & WBBatchNumber
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.