the thing is the sp is used to process customer deposits(cr) and withdrawals(dr) and print a stmt from the file.
the sp will do something like this;

delete from statement;
\\cr
insert into statement (code, dr, cr)
select dp.code, 0, dp.cr
from deposit dp
where dp.code = ........
\\dr
insert into statement (code, dr, cr)
select wt.code, wt.dr, 0
from withdrawal wt
where wt.code = ........
but before the end of processing another workstation wld call same sp and empty what is being processed. so my wish was to lock statement.mkd until one workstation completes its processing.
what am i doing wrong? how do i use the START TRANSACTION, COMMIT commands etc etc
hope my explanations are ok
nb. when i called the site location u gave i had the ff msg
The page you are looking for has moved or is no longer available.
thanks once again