Hi Willie,

Sounds like you have been busy (as usual). I hope all is well with you and you family.

Glenn

>Hi
>Since I am accessing the ASA database over the wire I do not want to open all tables at once. Depending on the type of update, I open these tables individually.
>

>	opropd = CREATEOBJECT('asadata')	&& CDE object
>	opropd.asasetup.cwhere = "bid='"+regbid + "'"
>	opropd.asasetup.OPEN()
>	IF !osync.openerror('asasetup')	&& Function to check if the table is open
>		RETURN .f.
>	ENDIF
>

>
>Ok I never used the CDE's closeall (opropd.closeall).
>
>Problem sorted.
>
>Thanks
>
>By the way, will you be attending the devcon in June?
>
>Regards
>Willie
>>Hi,
>>
>>>I open tables as needed throughout the class.
>>
>>This isn't generally what happens in a CDE (Codemine Data Environment). When you open the CDE, the OpenAll() method fires and the cursor objects are activated. How are you opening the tables? If you are opening tables "on the fly", you need to tell Codemine about them if you want them to be managed by Codemine - similarly, there is a process to follow if you close a managed cursor.
>>
>>Maybe you can post the code - it may be easier to see what is going on.
>>
>>Best,
>>
>>
>>
>>>Hi Gary
>>>>If you don't call the code in the separate prog, do you still get the error?
>>>mmm not really possible. The prg consist of a few lines of code which creates a class. Before I create the lass I create my data object (codemine data class). I open tables as needed throughout the class.
>>>
>>>The data class object is destroyed when the prg completes. On Clear everything it pops up with the connection manager error (cmconnectionmanager).
>>>
>>>The call stack is as follow:
>>>1. cmstart
>>>2. clearall
>>>3. clearenvironment
>>>4. cmconnectionmanager.connection1.destroy
>>>5. cmconnectionmanager.connection1.close
>>>6. cmconnectionmanager.connection1.error
>>>
>>>Thanks