I have a customized session that zooms to another session that allows you to select values for certain fields and then returns you to the original session, which now only displays the items matching your selection. Kind of a filter session. I get an error "transaction is on can't continue" error when trying to zoom to the session.

I had this problem a little while ago with another session and some suggested I recompile my script and that worked. I have done that with this session and I still get the error. I know its got something to do with db.retry and commit.transaction commands.

The error occurs when the script tries to run "execute(find.data)" in the script.

Can anyone shed more light on this problem I have?

You would see this, for example, if you tried to do an update on a record that had already been updated but not committed or aborted.

This message comes when you start a trasaction from within another transaction.

For example in your case: If you are zooming to another maintain session, then you are trying to start another transaction without completing the first one. You have to find a way to not start another transaction or complete the first one before you zoom.

For example:
if you have code like:

db.retry.point()
....................
db.retry.point() ( at this point you will get a error)
commit.transaction()
.............
...............
commit.transaction()

Haggis!

Are you still having problems with the transaction is on?

There is a check box on the maintain session (when setting up user defined buttons) that says something like "Complete transaction" (or something! - can't remember exactly what). Try checking that.

What this does is complete any transactions prior to zooming to the session. When the session returns and you try to filter, you do not have any outstanding transactions.

Please let me know how this goes.

Regards

MrMarco