Results 1 to 4 of 4

Thread: Real Disconnected Recordset

  1. Apr 8th, 2003, 08:34 PM #1
    xor_ax_ax
    xor_ax_ax is offline

    Thread Starter
    Member
    Join Date
    Mar 2003
    Location
    Jakarta, Indonesia
    Posts
    36

    Real Disconnected Recordset

    I am experienced that Disconected Recordset is not really disconnected. What I expected when using Disconnected
    Recordset is really get disconnected from the Server.

    I use Data Bound Control like dbGrid tobe bound with this
    recordset, and do a little update to the record. I do expect
    that this not affected the server but it did.

    I think I miss understood the role of Disconnected recordset.
    Is there any way to get it work ?

    Please Help.

    Thanks.
    Reply With Quote Reply With Quote
  2. Apr 9th, 2003, 02:04 AM #2
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Depends.

    How do you fill your recordset, and how are you disconnecting ?
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  3. Apr 9th, 2003, 04:57 AM #3
    xor_ax_ax
    xor_ax_ax is offline

    Thread Starter
    Member
    Join Date
    Mar 2003
    Location
    Jakarta, Indonesia
    Posts
    36
    Originally posted by swatty
    Depends.

    How do you fill your recordset, and how are you disconnecting ?
    VB Code:
    1. ' Connecting, cn is adodb.connection object

    2. set rs.activeconnection = cn

    3.  
    4. ' Disconnecting

    5. set rs.activeconnection = nothing
    Reply With Quote Reply With Quote
  4. Apr 9th, 2003, 05:03 AM #4
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Originally posted by xor_ax_ax
    VB Code:
    1. ' Connecting, cn is adodb.connection object

    2. set rs.activeconnection = cn

    3.  
    4. ' Disconnecting

    5. set rs.activeconnection = nothing
    It should work if you're disconnecting like you do.
    You cannot reconnect though with this recordset or the changes will be reflected.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width