The default Transaction object – PB Docs 125

The default Transaction object

SQLCA

Since most applications communicate with only one database,
PowerBuilder provides a global default Transaction object called SQLCA (SQL Communications
Area).

PowerBuilder creates the Transaction object before the application’s
Open event script executes. You can use PowerScript dot notation
to reference the Transaction object in any script in your application.

You can create additional Transaction objects as you need
them (such as when you are using multiple database connections at
the same time). But in most cases, SQLCA is
the only Transaction object you need.

Example

This simple example uses the default Transaction object SQLCA to connect to and disconnect
from an ODBC data source named Sample:

note.png Semicolons are SQL statement
terminators

When you use embedded SQL in
a PowerBuilder script, all SQL statements must
be terminated with a semicolon (;). You do not use
a continuation character for multiline SQL statements.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x