Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ado.delete problem

1 view
Skip to first unread message

Tim A

unread,
May 14, 2000, 3:00:00 AM5/14/00
to
I am connected to an Oracle database. I can successfully insert and
retrieve records from the database. I have used the SQL INSERT statement to
add records, and used a recordset to view records.

I wanted to delete a group of records. I retrieved a recordset of the
records that I wanted to delete. I issued the

rs.delete

statement, and I got an error indicating that this statement could not be
used in its current context. I issued the SQL DELETE statement and I could
delete the records with no problem.

What locking mechanism should I be using on the recordset? What cursor type
should I be using?

Thanks in advance


0 new messages