You should post the error message.
If the data is temporary you should look up temporary tables in the Oracle
documentation, then you wouldn't have to do what you are doing.
the sql command is delete from tableName not delete * from tablename. You
don't have a column list or projection in a delete.
Jim
"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 - 13:40:40 CST
