edit an ado recordset using datagrid 
Author Message
 edit an ado recordset using datagrid
who can tell me how to edit an ado recordset using datagrid when the ado
recordset contain some records that are totally the same.


Tue, 04 May 2004 16:17:02 GMT
 edit an ado recordset using datagrid

You can't .. it's that simple. Just like Enterprise Manager doesent let
you.. the old "to many rows effected by last query" bust
SQL doesnt want to update the wrong or to manny records so it just does
nothing but bust
You need a PK and if you got exact dupe rows you cant have one
there are a couple of work arounds I have made that do the trick depending
on the data your working with i.e. name/address stuff. inventory, ect.
What kinda data ya got there?
Harold


Quote:
> who can tell me how to edit an ado recordset using datagrid when the ado
> recordset contain some records that are totally the same.



Wed, 05 May 2004 01:31:28 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. edit an ado recordset using datagrid

2. VB6 & ADO Datagrid: cannot edit fields

3. Editing DB Info Using DataGrid

4. Reporting using ADO after editing using DAO.

5. Help:Editing field values of an ADO recordset returned from SQL SP

6. Help: Editing field values of ADO recordset from SQL db

7. Binding The DataGrid With ADO Recordset

8. DataGrid and ADO Recordset Troubles

9. ADO DataGrid: How to list a Recordset clicking then Button of a Cell

10. How to bind ADO recordset to DataGrid?

11. problem binding a datagrid to an ADO recordset


 
Powered by phpBB® Forum Software