>>I have a form (form2) which is called from another form (form1) having a
private datasession. After attempting to delete a record on form 2 which
fails because of database triggers and upon releasing both forms an unkown
datasession is left active. The only way I can get rid of this datasession
is by restarting fox.
>>
>>Any ideas?
>
>I have had that in the past...
>Basically, when the update occurs and the stored procedure crashes, the
data session appears in a half-baked update mode... Try using tablerevert()
or rollback, then close all from that data session.
the de can't close (and release the Datasession) since the SP failed and
didn't complete a ROLLBACK or END TRANSACTION
indeed completing or canceling the transaction clears the objref to the DE
and allows it to close (with the datassesion)
Arnon
Précédent
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