PowerBuilder编程中的事务处理剖析

Analysis of Transaction in PowerBuilder Programming

在数据库应用程序开发中,需着重考虑数据库事务处理,事务处理对于确保数据库的一致性和最大并发控制非常重要。通常,PowerBuilder对数据库的存取操作有两种方式:通过数据窗口(Datawindow)存取数据和通过嵌入式SQL语句存取数据,无论用哪种方式存取数据,都需事先与数据库建立连接关系,即启动事务,事务是PowerScript环境连接数据库的桥梁。该文主要论述Pow-erScript编程环境中事务对象的属性构成、事务与数据并发控制关系以及常用的事务处理语法。

In the database application development,transaction of database should be focused on considering.Transaction is important for database,it allows database to maintain consistency.Typically,there are two ways of PowerBuilder database access operations,access to data through datawindow and access data through the embedded SQL statements,either way access to data is subject to prior relationship with the database connection,in other words,starting the transaction,transaction is a bridge between the database and PowerScript.This paper discusses the attributes of transaction objects,the relationships between transaction and data concurrency control,and the common syntax of transaction in PowerScript programming environment.