Delete All Records From Table with VB

From: Mike <Mike_at_here.com>
Date: Sat, 15 Dec 2001 09:26:35 -0500
Message-ID: <3c1b59d2_3@corp.newsgroups.com>

Anyone know of a way to delete all records in a table using rdo in vb ?

Currently dropping table and creating it again. Is there a better way ?

Sample Code:
Dim rdoOracle As New rdoConnection

Dim myOracle As rdoResultset 'For Oracle tables.

'DROP TABLE.

On Error Resume Next
SQL = " DROP TABLE MY_ORACLE_TABLE "
Set myOracle = rdoOracle.OpenResultset(SQL, , , rdExecDirect)

'CREATE TABLE ROUTINE FOLLOWS...
Thanks for any help.

Mike

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Sat Dec 15 2001 - 08:26:35 CST