GetSystemGroup – PB Docs 2018
GetSystemGroup Description Returns a PowerBuilder internal system group. Syntax
|
1 |
GetSystemGroup() |
Return value pbclass or null on error. Usage GetSystemGroup returns the PowerBuilder internal system group, which contains all the system types such as PowerObject, NonVisualObject, Structure, Window, CommandButton, and so on. You can use this system group to obtain a system class. You might need…
Target – PB Docs 2018
Target property (DataWindow object) Description The columns and expressions whose data is transferred from the DataWindow to the OLE object. Applies to OLE Object controls Syntax PowerBuilder dot notation:
|
1 |
dw_control.Object.oleobjectname.Target |
Describe and Modify argument:
|
1 |
"oleobjectname.Target { = ' columnlist ' }" |
Parameter Description oleobjectname The name of the OLE Object control for which you want to get or set the data…
SAP Adaptive Server Enterprise Update – PB Docs 2018
SAP Adaptive Server Enterprise Update Database stored procedures that perform updates only and do not return result sets are handled in much the same way as procedures that return result sets. The only difference is that after the EXECUTE procedure_name statement is executed, no result sets are pending and no CLOSE statement is required. Using the…
DECLARE Procedure – PB Docs 2018
DECLARE Procedure SQL statement Description Declares a procedure for the specified transaction object. DBMS-specific Not all DBMSs support stored procedures. Syntax
|
1 2 3 4 |
DECLARE ProcedureName PROCEDURE FOR    StoredProcedureName    @Param1=Value1, @Param2=Value2,...    {USING TransactionObject}; |
Parameter Description ProcedureName Any valid PowerBuilder name. StoredProcedureName Any stored procedure in the database. @Paramn=Valuen The name of a parameter (argument) defined in the stored procedure and a valid PowerBuilder expression; represents the…
Properties for Picture controls in DataWindow objects – PB Docs 2018
Properties for Picture controls in DataWindow objects An x in the M (Modify) column means you can change the property. When (exp) is included in the description, you can specify a DataWindow expression as the value for that property. Property for a Picture M Description AccessibleDescription x A description of the control for use by…
Count – PB Docs 2018
Count DataWindow expression function Description Calculates the total number of rows in the specified column. Syntax
|
1 |
Count ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } ) |
Argument Description column The column for which you want the number of rows. Column can be the column name or the column number preceded by a pound sign (#). Column can also be an expression that includes a reference to…
Axis – PB Docs 2018
Axis property (DataWindow object) Description The list of items or the expression associated with an axis of a graph. Each item is separated by a comma. You can ask for the list of categories on the Category axis, the series on the Series axis, or the values on the Values axis. Applies to Graph controls…
GetArrayItemType – PB Docs 2018
GetArrayItemType Description Obtains the datatype of an item in an array. Syntax
|
1 |
GetArrayItemType( pbarray array, pblong dim[ ]) |
Argument Description array A valid pbarray structure. dim A pblong array to hold the indexes of each dimension of the array. The size of the array must equal the dimensions of array. Return value pbuint. See also Get<type>ArrayItem GetArrayInfo GetArrayLength IsArrayItemNull NewBoundedObjectArray…
Syntax 4: For ListView controls – PB Docs 2018
Syntax 4: For ListView controls Description Adds an item to a ListView control by referencing all the attributes in the ListView item. Applies to ListView controls Syntax
|
1 |
listviewname.AddItem ( item ) |
Argument Description listviewname The name of the List View control to which you are adding a picture or item item The ListViewItem variable containing properties of the…
Microsoft SQL Server Name qualification – PB Docs 2018
Microsoft SQL Server Name qualification Since PowerBuilder does not inspect all SQL statement syntax, you can qualify SQL Server 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.