CompuServe Thread

Recordset Delete All

2 messages in this thread
#30333From: Israel BurmanJul 8, 1994 6:34 PM
Is there a function for a Recordset to delete all records? Thanks Israel
#30502From: Ronald LaeremansJul 11, 1994 9:37 AM
Israel, There isn't a function per-se. If yoi want to avoid going crazy waiting, your best bet is to use CDatabase::ExecuteSQL("delete from Mytable") which will get rid of all your records in the table. An even faster option for very large tables is to drop the table and then recreate it. -Ronald-