Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete All Records From Table with VB
can't you just do
delete from table tableName
or
truncate table tableName;
(caution, while truncate is faster you cannot rollback the transaction and
it issues its own commit)
Jim
"Mike" <Mike_at_here.com> wrote in message
news:3c1b59d2_3_at_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 - 10:14:21 CST