Duplicate Rows and the Delete Method

[Yesca]

Using visual basic 6 and ado:

I've created a recordset to a sql table using a client side cursor. my example table contains complete duplicate rows. if i move my recordset to one of the duplicates and do a .recordset.delete, all the duplicated rows are removed. This "functionality" is removed if my cursor is set to the server side.

Now, I need the client side for the bookmarks, but i really don't need any application removing rows from my database that i haven't told it to remove.

How do i setup a client-side adodb.recordset and have it behave the way i want?

 

[aalmeida]

Yesca!

What is the database you are using? what version?

It could be that if you are using SQL Server that would be bnetter to write a SQL code to bring only the records you want to work with (without duplicates) I think it would evem be faster. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"