Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

CONNECT – PB Docs 125 – PowerBuilder Library

CONNECT – PB Docs 125

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 12.5
  5. CONNECT – PB Docs 125

CONNECT SQL statement

Description

Connects to a specified database.

Syntax

Parameter

Description

TransactionObject

The name of the transaction object containing
the required connection information for the database to which you
want to connect. This clause is required only for transaction objects
other than the default (SQLCA).

Usage

This statement must be executed before any actions (such as INSERT, UPDATE, or DELETE)
can be processed using the default transaction object or the specified
transaction object.

note.png Error handling

It is good practice to test the success/failure code
after executing a CONNECT statement.

Examples

[Example 1]

This statement connects to the database specified in the default transaction
object:

[Example 2]

This statement connects to the database specified in the transaction
object named Emp_tran:

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 12.5
PB Docs 125 Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older PowerScript Reference
August 10, 2023
Was this article helpful?
3
4
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x