动态SQL在PowerBuilder中的应用

Application of dynamic SQL in PowerBuilder

在标准的SQL语句中,数据定义、数据操纵和数据控制等语句,对象名(表名、字段名等)必须显式地给出。而在一些复杂的数据库应用中,经常遇到SQL语句中对象只有在应用程序执行过程才确定,这就不能使用标准SQL语句而要应用动态SQL(dynamic SQL)语句。文章介绍了在PB中使用动态SQL语句的四种类型,并设计了四个常用的动态SQL的PB例程,这些例程可以应用于数据库的各种应用中。

Object name including table name and field name must be explicitly appeared in standard SQL statements, for example data definition ,data manipulation and data control statements. However, in some complex data applications, many SQL statements are only ensured in the process of application programms. Then standard SQL statements have to be replaced by dynamic SQL statements in above those process. In this paper, four formats of application of dynamic SQL are presented to PowerBnilder and designs a procedure for each format. These procedures may apply to most database＇s applying programs.