unable to update record

unable to update record of axapta database using c#.net code,

axrecord.executestmt(“select * from %1”);

axrecord.set_field(“name”,“vijender reddy”);

axrecord.update(); ------------------------------- error

im getting error :

Cannot edit a record in Production pools (ProdPool).
Update must be performed inside a transaction.

You should add axrecord.ttsbegin or begintransaction in front and axrecord.ttscommit or committransaction at the end.