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!