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')
opropd.asasetup.cwhere = "bid='"+regbid + "'"
opropd.asasetup.OPEN()
IF !osync.openerror('asasetup')
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