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

DataWindow Reference – Page 70 – PowerBuilder Library

DataWindow Reference

  2. DataWindow Reference

GetSeriesStyleSymbolValue – PB Docs 125

GetSeriesStyleSymbolValue method (Graphs in DataWindows) Description Returns the symbol associated with a series in a graph in a DataWindow object. You must call GetSeriesStyleLine first to retrieve the line style information. (See GetSeriesStyle for information about this method.) Controls DataWindow Web ActiveX DataWindow control Syntax [Web ActiveX]

Argument Description dwcontrol A reference to a DataWindow…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

Concatenation operator in DataWindow expressions – PB Docs 125

Concatenation operator in DataWindow expressions The concatenation operator joins the contents of two variables of the same type to form a longer value. You can concatenate strings and blobs. To concatenate values, you use the plus sign (+) operator. Table 1-11: Using expressions with concatenation operator String expression Value “over” + “stock” overstock Lname +…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

GetSeriesStyleLineStyle – PB Docs 125

GetSeriesStyleLineStyle method (Graphs in DataWindows) Description Returns the line style associated with a series in a graph in a DataWindow object. You must call GetSeriesStyleLine first to retrieve the line style information. (See GetSeriesStyle for information about this method.) Controls DataWindow Web ActiveX DataWindow control Syntax [Web ActiveX]

Argument Description dwcontrol A reference to a…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

Using a transaction object with the Web ActiveX – PB Docs 125

Using a transaction object with the Web ActiveX When to use a separate transaction object Both the Web ActiveX and the Transaction Object control can establish a database connection. The one you use depends on your needs. There are two main reasons to use the Transaction Object control: You can make one database connection for…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

GetSQLErrText – PB Docs 125

GetSQLErrText method (Transaction Object control) Description Reports the database vendor’s error message for the most recent database operation. Controls Web ActiveX Transaction Object control Syntax

Return Values String. The text of the error message. Usage Call GetSQLCode to find out if an error occurred before calling GetDBCode and GetSQLErrText to get details about the error….

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

GetSQLReturnData – PB Docs 125

GetSQLReturnData method (Transaction Object control) Description Returns information reported by the DBMS for the most recent database operation. Controls Web ActiveX Transaction Object control Syntax

Return Values Number. A value whose meaning is determined by the database vendor. Usage The numeric return value is different from the value of the SQLReturnData property for the PowerBuilder…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

GetSQLNRows – PB Docs 125

GetSQLNRows method (Transaction Object control) Description Reports the number of rows affected by the most recent database operation. Controls Web ActiveX Transaction Object control Syntax

Return Values Number. The number of affected rows. Usage The number of rows is supplied by the database vendor, so the meaning may not be the same in every DBMS….

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

GetSQLCode – PB Docs 125

GetSQLCode method (Transaction Object control) Description Reports a code indicating the success or failure of the most recent database operation. Controls Web ActiveX Transaction Object control Syntax

Return Values Number. Possible values are: 0 – Success 100 – Not found -1 – Error Usage When GetSQLCode reports an error, call GetDBCode to get the vendor’s…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

Properties of the Transaction Object control – PB Docs 125

Properties of the Transaction Object control DataWindow object property Transaction Object properties provide the information necessary to connect to a particular database. In a Web page, you specify values for ActiveX properties using the HTML PARAM element.

Properties Property Value AutoCommit Number. The automatic commit indicator. Values are: 0 – Do not commit automatically…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older

LookUpDisplay – PB Docs 125

LookUpDisplay DataWindow expression function Description Obtains the display value in the code table associated with the data value in the specified column. Syntax

Argument Description column The column for which you want the code table display value Return Values String. Returns the display value when it succeeds and the empty string (“”) if an…

Powerbuilder Documentation 12.5 DataWindow Reference PB Docs 125 Powerbuilder DataWindow technology Powerbuilder DataWindow User Guide Powerbuilder Documentation Powerbuilder Documentation 12.5 Powerbuilder Documentation Older