[VB6] Have a selection in a recordset. How do i easily del..

Post some code and SQL statements

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

"Zeppo" wrote in message

 > On Sat, 19 Feb 2005 23:42:21 +0100, Zeppo

 >
  > >As said: my app lets users select records.
  > >They can choose to delete the whole current selection.
  > >
  > >i tried rs.delete, but that gave me an error.
  > >
  > >Primary keys are in available in recordset.
  > >
  > >Any thoughts?
 >
 > to be precise: i get a lovely
 >
 > "insufficient key column information for updating or refreshing"
 >
 > error when trying to rs.delete
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: [VB6] Have a selection in a recordset. How do i easily del.. 

this post is not archived.
 >> Stay informed about: [VB6] Have a selection in a recordset. How do i easily del.. 

On Sat, 19 Feb 2005 23:23:00 GMT, "Veign" wrote:

 >Post some code and SQL statements

Well, there is not much to show.
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 .......<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: [VB6] Have a selection in a recordset. How do i easily del.. 

Zeppo wrote:


 >
 >
  >>Post some code and SQL statements
 >
 >
 > Well, there is not much to show.
 > 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 .......

Use an ADODB.Command object.

<a style='text-decoration: underline;' href="http://juicystudio.com/tutorial/vb/database.asp" target="_blank">http://juicystudio.com/tutorial/vb/database.asp</a>

Look for the section entitled 'The SQL Delete Statement'<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: [VB6] Have a selection in a recordset. How do i easily del..