![]() |
#10 |
Участник
|
Цитата:
X++: global::executeSql(strFmt("update Batch set ExecutedBy = 'вася', CreatedBy = 'вася' where recId = %1", Batch.RecId)); global::executeSql(strFmt("update BatchJob set CreatedBy = 'вася' where recId = %1", Batch.BatchJobId)); где X++: static server void executeSql(str _sql) { SqlSystem sqlSystem = new SqlSystem(); Connection connection; Statement statement; SqlStatementExecutePermission permission; ; connection = new Connection(); statement = connection.createStatement(ResultSetType::Dynamic, ResultSetConcurrency::Updatable); sqlSystem = new SqlSystem(); connection.ttsbegin(); permission = new SqlStatementExecutePermission(_sql); permission.assert(); statement.executeUpdate(_sql); CodeAccessPermission::revertAssert(); connection.ttscommit(); } |
|
|
За это сообщение автора поблагодарили: raz (1), AnGor (1). |