how i delete record from sqlserver database in delphi?

nowshadcv · #1 (**permalink**) 09-09-08, 08:36

Frineds plz help me.......i am doing database manipulation(insert,update,delete etc) in sqlserver.My front end is Delphi.I have a delete button in my form.My aim is to delete record from database.How i will do?If anyone knows the source code(try to write code using SQLOLEDB) plz give me .

kalsig · #2 (**permalink**) 10-09-08, 02:20

Try the following site from where you can download third party components in Delphi and use the data access components like database navigation buttons to move through records, add, edit or delete records of your SQL tables.

http://www.devart.com/sdac/download.html

nowshadcv · #3 (**permalink**) 10-10-08, 10:32

i am trying 2 solve this pblm using real delphi source code.

jkuiper · #4 (**permalink**) 01-02-09, 14:51

If you use ADOQuery to SQLServer and you have an datalink on it, just use ADOQuery.delete to delete the record.
Otherwise create a SQL in your query-componment and use ExecSQL to execute your SQL