Changing the source on an ADO recordset bound to controls 
Author Message
 Changing the source on an ADO recordset bound to controls

I have written a class that acts as a datasource for the boundcontrols on my
form but I need to change the source for the recordset in the class.  If I
close the recordset, change the source and try to reopen it, I get an error
saying that it is already open.  How can I change the source of the
recordset?

David Francis



Mon, 05 Nov 2001 03:00:00 GMT  
 Changing the source on an ADO recordset bound to controls
Check Recordset.ActiveConnection property after you close recordset. It must
be Nothing. Otherwise recordset didn't close because something still
references it (boundcontrol).


Quote:
> I have written a class that acts as a datasource for the boundcontrols on
my
> form but I need to change the source for the recordset in the class.  If I
> close the recordset, change the source and try to reopen it, I get an
error
> saying that it is already open.  How can I change the source of the
> recordset?

> David Francis



Tue, 06 Nov 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. OLE Bound control won't bind ADO source

2. OLE Bound control won't bind ADO source

3. OLE Bound control won't bind ADO source

4. Bind an ado recordset directly to an ado data control (adodc)

5. VB6 ADO Classbinding: unable to change recordset source

6. Error 91 when trying to bind an ADO Recordset to an MSFlexGrid Control

7. DataGrid Control (ADO recordset bound) and Insert events

8. Bound controls not updating ADO with adodc.recordset.update command

9. Error 91 when trying to bind an ADO Recordset to an MSFlexGrid Control

10. Deploying ADO Data bound controls / changing connection string

11. Data designer bound controls seem to lose their binding to the recordset with Requery

12. Data designer bound controls seem to lose their binding to the recordset with Requery

 

 
Powered by phpBB® Forum Software