Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
I'v got sort of a problem, i'm using an MS Access database combined with a delphi program. I use the Datasource and the adoquery compontents to connect with the database.
Now i'm used to work with SQL so i know all the commands and such, but as far as i know you can only use these command to get records from de database (adoquery.sql.add('SELECT * FROM Table'))
now i already made the insert work (NOT with an sql command, is that even possible) i used:
adoquery.fieldname(name) := value;
but now i want to delete a record, or all the record.
i tried a lot of things, but nothing works, these things i tried and i think it should be any of these, tried more but don't think that's even possibile:
ADOQuery.Delete;// database is blocked or something
ADOQuery.Post;// not really sure i need this
ADOquery.DeleteRecords(); // this gives an error something like it's not in the right context, but i don't know the right one..
So anybody knows how i delete records from de database?
Thanx in advance.