neil_turner
Registered User.
- Local time
- Today, 18:05
- Joined
- Mar 4, 2002
- Messages
- 16
Hi All,
I have an extremely strange problem with a recordset. I have a recordset declared in a module as a public recordset. I then use this recordset to query a external databse (which is oracle) using ODBC and DAO. This returns the query fine, I envoke the 'edit' method on the recordset then return control to a form to make changes. Its when I write back these changes that I get a rather strange problem.
when I issue the 'update' method nothing happens, the code steps through fine yet no actual update takes place.
The situation: Recordset defined in a module with loads of other global variables 'public rsData as recordset', I have a sub procedure in another module that opens the recordset with a query that is passed to it. I Have a form that modifys the content of the recordset, and upon button press it luanches another sub procedure to make the change.
When I test this in a module it all works fine, it seems that once the code finishes executing within the module it forgets that it has changes to update.
If I query the field values of the recordset it has all the changes that should be made, and if I dont use the 'edit' method it kicks of an error indicating that the recordset cannot be updates as no edit has been performed.
This is really puzzeling me. Anybody got any ideas? Im about to try and do the same using rdo and a result set then if its the same ADO and a recordset!
Thanks
Neil
I have an extremely strange problem with a recordset. I have a recordset declared in a module as a public recordset. I then use this recordset to query a external databse (which is oracle) using ODBC and DAO. This returns the query fine, I envoke the 'edit' method on the recordset then return control to a form to make changes. Its when I write back these changes that I get a rather strange problem.
when I issue the 'update' method nothing happens, the code steps through fine yet no actual update takes place.
The situation: Recordset defined in a module with loads of other global variables 'public rsData as recordset', I have a sub procedure in another module that opens the recordset with a query that is passed to it. I Have a form that modifys the content of the recordset, and upon button press it luanches another sub procedure to make the change.
When I test this in a module it all works fine, it seems that once the code finishes executing within the module it forgets that it has changes to update.
If I query the field values of the recordset it has all the changes that should be made, and if I dont use the 'edit' method it kicks of an error indicating that the recordset cannot be updates as no edit has been performed.
This is really puzzeling me. Anybody got any ideas? Im about to try and do the same using rdo and a result set then if its the same ADO and a recordset!
Thanks
Neil
