Powerbuilder Documentation 2017

Powerbuilder Documentation 2017

OLEObject object type – PB Docs 2017

OLEObject object type PowerBuilder’s OLEObject object type is designed for automation. OLEObject is a dynamic object type, which means that the compiler will accept any property names, function names, and parameter lists for the object. PowerBuilder does not have to know whether the properties and functions are valid. This allows you to call methods and…

Syntax 2: For animation controls – PB Docs 2017

Syntax 2: For animation controls Description Displays a specific frame in an AVI clip in an animation control. Applies to Animation controls Syntax

Argument Description animationname The name of animation control displaying the AVI clip s A long value in the range 0 to 65,535 indicating the frame to display Return value Integer. Returns…

How the synchronization works – PB Docs 2017

How the synchronization works How MLSync events are implemented The MLSync object in a PowerBuilder application and the dbmlsync process communicate with each other by sending messages between two windows, as shown in the following figure. The window that the MLSync object creates uses an internal function, MlSyncControlWindowProc, to process these messages. The Synchronize function adds a…

CONNECT – PB Docs 2017

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…

Using the OLE DB Interface – PB Docs 2017

Using the OLE DB Interface Contents About the OLE DB interface Preparing to use the OLE DB interface Defining the OLE DB interface About this chapter This chapter describes the OLE DB interface and explains how to prepare to use this interface and how to define the OLE DB database profile. For more information This…

Declaring arrays – PB Docs 2017

Declaring arrays Contents Values for array elements Size of variable-size arrays More about arrays Description An array is an indexed collection of elements of a single datatype. In PowerBuilder, an array can have one or more dimensions. One-dimensional arrays can have a fixed or variable size; multidimensional arrays always have a fixed size. Each dimension…

SAP Adaptive Server Enterprise Name qualification – PB Docs 2017

SAP Adaptive Server Enterprise Name qualification Since PowerBuilder does not inspect all SQL statement syntax, you can qualify Adaptive Server Enterprise catalog entities as necessary. For example, the following qualifications are all acceptable: emp_name employee.emp_name dbo.employee.emp_name emp_db.dbo.employee.emp_name Document get from Powerbuilder help Thank you for watching.

SELECT – PB Docs 2017

SELECT SQL statement Description Selects a row in the tables specified in RestOfSelectStatement. Syntax

Parameter Description RestOfSelectStatement The rest of the SELECT statement (the column list INTO, FROM, WHERE, and other clauses). TransactionObject The name of the transaction object that identifies the database containing the table. This clause is required only for transaction objects other…

ODBC Retrieval using cursors – PB Docs 2017

ODBC Retrieval using cursors Retrieval using cursors is conceptually similar to the singleton SELECT discussed earlier. The main difference is that since there can be multiple rows in a result set, you control when the next row is fetched into PowerScript variables. For example, if you expect only a single row to exist in the…

DISCONNECT – PB Docs 2017

DISCONNECT SQL statement Description Executes a COMMIT for the specified transaction object and then disconnects from the specified database. Syntax

Parameter Description TransactionObject The name of the transaction object that identifies the database you want to disconnect from and in which you want to permanently update all database operations since the previous COMMIT, ROLLBACK, or…