It needs the same connection it had when the cursor was created. I do not understand how TABLEUPDATE and TABLEREVERT can work with the connection closed.

>i am using CA (create by Mark E. McCasland CABuilder) in a custom DE. What I am trying to accomplish is the following.
>
>I want to be able to only keep the ODBC connection open when I need to:
> Requery()
> TableUpdate()
> TableRevert()
>
>Once I am done, I want to close the connection.
>
>Ok, TableUpdate & TableRevert work after I close my connection. However, the REQUERY(), same with ca.CursorRefresh(), always fails. I check ERROR and it tells me that the "connection handle is invalid". Which I can understand, I am not connected. So, even if I reconnect to the ODBC data and fire Requery(), I get the same error.
>
>Any ideas?????
>TIA
>Mark Moore