Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete All Records From Table with VB
Thanks for the info Jim.
I had tried:
DELETE * FROM TABLENAME;
Which gives an error message.
I'll truncate and see if it works. No problem on rollback as the data is only temporary.
Mike
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news:xFKS7.1613$KY.76301_at_rwcrnsc54...
> 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! =-----
>
>
-----= 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 - 13:25:09 CST