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