Friday, March 11, 2011

callsection and SQL actions are mutually exclusive

It is due to Commit in the database. It is mutually
exclusive so that there is no inconsistency in the database.
In Brief.....
Usually a commit takes place after the STEP, not after the
ACTION. Both SQL as well as CallSection are Actions. If they
were not mutually exclusive you could execute an SQL (update,
insert or so) and before comitting go to an entirely different
programm where you would work on the same data, change that data
and then come back to the originating program to issue the
commit on a dataset that has changed. I think you can see the
potential errors that can come up.

2 comments: