Has anyone managed to use START TRANSACTION and use a different ISOLATION LEVEL from the default?
I am trying: &sql(START TRANSACTION %COMMITMODE EXPLICIT ISOLATION LEVEL READ COMMITTED) Which seems to make no difference over &sql(START TRANSACTION %COMMITMODE EXPLICIT) This means that whilst the Transaction is in progress other users can see the records that I have updated/added. This should not be the case. Other users should not see the updates untill an %sql(COMMIT) is done. Any help would be appreciated. Regards Oliver.
