problems with transactions

To start a transaction, use BEGINTRANS
To make the changes final, use COMMITTRANS
To undo all changes made since calling begintrans, call ROLLBACKTRANS

You may be calling your begintrans at the wrong time, or not at all. If you are going to use transactions, be sure to be clear on when to use them

If i do rollback statement in my code all my querydefs and recorrdsets are not set anymore
and i all have to define them again. Anyone
knows something about this.