User-Defined Enumerations – PB Docs 125
User-Defined Enumerations To use enumerations that you import from a .NET assembly, you must surround the enumeration references in a conditional compilation block that is valid for your .NET target environment. Declaring .NET enumerations in PowerScript You must also append an exclamation mark (�!�) to each of the enumeration�s constant strings that you declare in…
TRS – PB Docs 125
TRS database parameter Description Specifies whether you want your application to connect to a database through the DirectConnect server using: DirectConnect Access Service for DB2/MVS DirectConnect TRS Gatewayless connection using OpenServerConnect Controls DIR Sybase DirectConnect Syntax
|
1 |
TRS=<span>value</span> |
Parameter Description value Specifies how your application should connect to a database through the DirectConnect server. Values are:…
SQLQualifiers – PB Docs 125
SQLQualifiers database parameter Description Sets the level of qualification for identifiers (table and column names) in SQL statements when you connect to a database. This affects behavior in DataWindow objects. When PowerBuilder qualifies a table or column name, it prefixes it with the name of the owner. For example, if a user named Fran owns…
BindSPInput – PB Docs 125
BindSPInput database parameter Description Specifies that PowerBuilder bind input parameters in dynamic SQL statements when executing a stored procedure. Controls ADO.NET O90 Oracle9i O10 Oracle 10g SNC SQL Native Client for Microsoft SQL Server Syntax
|
1 |
BindSPInput=<span>value</span> |
Parameter Description value Specifies whether you want to bind input parameters in dynamic SQL statements when executing stored procedures….
Errors in property and data expressions and the Error event – PB Docs 125
Errors in property and data expressions and the Error event A DataWindow control’s Error event is triggered whenever an error occurs in a data or property expression at execution time. These expressions that refer to data and properties of a DataWindow object might be valid under some execution-time conditions but not others. The Error event…
Planning and building the DataWindow object – PB Docs 125
Planning and building the DataWindow object To design the report, you create a DataWindow object. You select the data source and presentation style and then: Sort the data Create groups in the DataWindow object to organize the data in the report and force page breaks when the group values change Enhance the DataWindow object to…
Accessing the database – PB Docs 125
Accessing the database Before you can display data in a DataWindow control, you must get the data stored in the data source into that control. The most common way to get the data is to access a database. An application goes through several steps in accessing a database: Set the appropriate values for the transaction…
Sharing information – PB Docs 125
Sharing information The ShareData method allows you to share a result set among two different DataStores or DataWindow controls. When you share information, you remove the need to retrieve the same data multiple times. The ShareData method shares data retrieved by one DataWindow control or DataStore (called the primary DataWindow) with another DataWindow control or…
Providing query ability to users – PB Docs 125
Providing query ability to users When you call the Retrieve method for a DataWindow control, the rows specified in the DataWindow object’s SELECT statement are retrieved. You can give users the ability to further specify which rows are retrieved during execution by putting the DataWindow into query mode. To do that, you use the Modify…
Names for DataWindow controls and DataWindow objects – PB Docs 125
Names for DataWindow controls and DataWindow objects There are two names to be aware of when you are working with a DataWindow: The name of the DataWindow control The name of the DataWindow object associated with the control The DataWindow control name When you place a DataWindow control in a window or form, it gets…