Click to See Complete Forum and Search --> : Disconnected Recordset


Ahtsham Ul Haq
July 31st, 2000, 10:57 PM
I am using Disconnecting Recordset.I have created
Disconneced recordset in a function which is in
ActiveX dll.I Have received data from this recordset successfully and displayed it at client side. Problem is occured when i try to update the record.
I am using ADOR recordset at client side.
Please Help me with a sample code which contains
properties of ADOR recordset beacuse I face failure in ADOR recordset (e,g)rs.fields(0).value=Text1.

Life is Temporary

Johnny101
August 1st, 2000, 11:18 AM
what's the error you are getting? what kind of recordset are you opening in the dll? if you open a readonly cursor in the dll and then return that to the client - yuo still can't update it. you'll have to open a dynamic cursor in the dll, send it back, do your updates (your example code is fine) and then send it back to the dll, and then back to the database.

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

Ahtsham Ul Haq
August 1st, 2000, 08:38 PM
Thanks for Helping.I was trying an un specified cursor.Now i have use Dynamic Cursor problem have solved.


Life is Temporary