[VB6 /ADO] Delete statement: Delete all underlying records..

I couldn't figure this one out:
my app lets users select records, that are displayed in a datagrid
They can then choose to delete the whole current selection.

i tried rs.delete, but that gave me an error.
Primary keys are in available in recordset.
to be precise: i get a lovely
"insufficient key column information for updating or refreshing"
error when trying to rs.delete

Basically, i filled an ado recordset with a sql query.
The recordset is shown in a datagrid.
Of course i could delete every record one by one, but i was looking
for a way to easily delete all records. As said: the primary key is
part of the recordset.
Rs,delete didn't work. Is there a way to delete all records in 1 SQL

Something like:

DELETE * FROM mytable WHERE id IN .......

Answered in another newsgroup...

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
<a rel="nofollow" style='text-decoration: none;' href="http://www.veign.com/vrc_main.asp" target="_blank">http://www.veign.com/vrc_main.asp</a>
--

"Zeppo" wrote in message

 > I couldn't figure this one out:
 > my app lets users select records, that are displayed in a datagrid
 > They can then choose to delete the whole current selection.
 >
 > i tried rs.delete, but that gave me an error.
 > Primary keys are in available in recordset.
 > to be precise: i get a lovely
 > "insufficient key column information for updating or refreshing"
 > error when trying to rs.delete
 >
 > Basically, i filled an ado recordset with a sql query.
 > The recordset is shown in a datagrid.
 > Of course i could delete every record one by one, but i was looking
 > for a way to easily delete all records. As said: the primary key is
 > part of the recordset.
 > Rs,delete didn't work. Is there a way to delete all records in 1 SQL
 >
 > Something like:
 >
 > DELETE * FROM mytable WHERE id IN .......