Ok, thanks everyone.
The soultion is to put
this.datasource=.null.
in the Destroy method. Doing oCA.datasource=.null. in the code before releasing oCA doesn't do it. Don't figure.
Thanks again,
Dennis
>>I have a subclassed cursoradapter using ADO. I create it the object and it works. However, any successive creations of this cursoradpater class, on the same table or a different one, returns an error when you do a .cursorfill():
>>
>>ADODB.RECORDSET: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
>>
>>CLEAR ALL clears this condition. Releasing the object variable for the first cursoradapter does not. I am using SQL Server.
>>
>>The condition occurs whether or not a .cursorfill() is done with the first object.
>>
>>Has anyone run into anything like this before and make suggestions as to a solution?
>>
>>Thanks,
>>
>>Dennis
>
>Hi Dennis,
>
>Try to set FetchSize=-1 for your CA subclass.
>
>Thanks,
>Aleksey.
>
>Thanks,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement