파워빌더 교안 9

목차

*Connecting an Application to a Database

*What Is a Transaction Object?

*Creating and Initializing Transaction Objects

*Populating Transaction Objects

*Using a Transaction Object to Connect to a Database

*Disconnecting from a Database

*Embedded SQL

본문내용

Referencing Variables in SQL Statements
Values returned from a database using SQL require program storage (variables)
Variables of the appropriate data type must be declared
Within a SQL statement, program variables must be preceded by a colon
Example
string ls_department
long ll_deptid
...
SELECT dept_name into :ls_department FROM department
WHERE dept_id = :ll_deptid
USING SQLCA ;
Summary
Use a transaction object to access a database from an application. Set transaction object properties with appropriate values for the desired database.
Use SQL CONNECT to establish the connection.
Each concurrent database connection requires its own transaction object.
Declare a variable of type transaction and use CREATE to build a transaction object.
Summary
Use ProfileString( ) to retrieve values from a preferences or INI file.
Disconnect from a database when you no longer need to be connected.
Destroy transaction objects created by an application when no longer needed.
PowerBuilder supports ANSI-standard SQL commands and other extensions in PowerScript.

키워드

파워빌더,   교안,   Connecting,   Application,   Database