There is a extra '*' sign in your statement.
It should be
delete from TABLENAME;
"Mike" <Mike_at_here.com> wrote in message
news:3c1b9fad$1_4_at_corp.newsgroups.com...
> 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 - 16:01:15 CST
