>Hello All,
>
>Has anyone encountered Error 1549: Datasession # cannot be released with open transactions?
>
>This is occuring for a client and I can't seem to figure out why. Was just wondering if anyone is familiar with this error and could give me some insight on it.
>
>Thanks in advance,
>
>--Mike
If you use buffering, before you close the form, you have to either save pending changes, or undo them. I don't remember exactly, right now, whether the omission to do so will cause this precise error message.
Also, if you use BEGIN TRANSACTION, you should finish the transaction with END TRANSACTION (or undo it with ROLLBACK) before you exit your form.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)