How do i delete a record set???
-
i am using the odbcrecordset class from the threat: www.codeproject.com/database/odbcrecordset.asp but i don't know how i can delete a recordset in my database? someone has an idea??? thanx for help!!! tom.
-
i am using the odbcrecordset class from the threat: www.codeproject.com/database/odbcrecordset.asp but i don't know how i can delete a recordset in my database? someone has an idea??? thanx for help!!! tom.
:confused: What do you mean by recordset? Do you mean you want to delete all of the data that is contained in your recordset? Or do you want to delete an entire table or view? CRecordset (which ODBCRecordset is based on) has a Delete() function, which will delete the currently selected record. You could just loop through each record and delete it from the database. If you want to drop an entire table or view, you should use the CDatabase class. Look at the ExecuteSQL() function.