ODBC Retrieval – PB Docs 2017
ODBC Retrieval PowerBuilder uses a construct similar to cursors to support retrieval using database stored procedures. PowerBuilder supports four embedded SQL statements that involve database stored procedures: DECLARE procedure_name PROCEDURE FOR … EXECUTE procedure_name FETCH procedure_name INTO … CLOSE procedure_name See also ODBC DECLARE and EXECUTE ODBC EXECUTE ODBC FETCH ODBC CLOSE Document get from…
CONTINUE – PB Docs 2017
CONTINUE Description In a DO…LOOPÂ or a FOR…NEXTÂ control structure, skips statements in the loop. CONTINUE takes no parameters. Syntax
|
1 |
CONTINUE |
Usage When PowerBuilder encounters a CONTINUEÂ statement in a DO…LOOPÂ or FOR…NEXTÂ block, control passes to the next LOOPÂ or NEXTÂ statement. The statements between the CONTINUEÂ statement and the loop’s end statement are skipped in the current iteration of the loop….
SetPosition – PB Docs 2018
SetPosition method (DataWindows) Description Moves a control within the DataWindow to another band or changes the front-to-back order of controls within a band. Applies to DataWindow type Method applies to PowerBuilder DataWindow control, DataWindowChild object, DataStore object Syntax PowerBuilder
|
1 |
integer dwcontrol.SetPosition ( string controlname, string band, boolean bringtofront ) |
Argument Description dwcontrol A reference to a DataWindow control or DataStore. controlname The name of…
Using the Database painter – PB Docs 2019
Using the Database painter Contents Modifying database preferences Logging your work To open the Database painter, click the Database button in the PowerBar. About the painter Like the other PowerBuilder painters, the Database painter contains a menu bar, customizable PainterBars, and several views. All database-related tasks that you can do in PowerBuilder can be done…
Select Declared Procedure dialog box – PB Docs 2021
Select Declared Procedure dialog box Description Select a declared procedure to paste into the current script. Options Declared Procedures Lists the procedures that have been declared. Select the procedure you want to paste and click OK. Actual Procedure Source Displays the source code for the procedure selected in the Declared Procedures box. See also To…
Example: Calling PowerBuilder functions – PB Docs 2021
Example: Calling PowerBuilder functions In this code fragment, the class and method ID returned by calls to the IPB_Session GetClass and GetMethodID methods are used to initialize a PBCallInfo structure, called ci, using the IPB_Session InitCallInfo method. After a new pbstring variable is created, the value of that string is set to the value of…
Using the style – PB Docs 2022
Using the style Contents Building a form with the custom form style Managing the use of form styles Once you complete a form style (or at least have a version that you want to test), you can put it to use. To make a style available to InfoMaker users: Make sure the window and menu…
C0192 Compiler Error – PB Docs 2022
C0192 Compiler Error Message text Declaration using descendant’s nested type type2 not supported. type1 is an ancestor of type2. Document get from Powerbuilder help Thank you for watching.
Chapter 6 Working with Libraries – PB Docs 120
Chapter 6 Working with Libraries About this chapter PowerBuilder stores all the PowerScript objects you create in libraries. This chapter describes how to work with your libraries. Contents Topic About libraries Opening the Library painter About the Library painter Working with libraries Searching targets, libraries, and objects Optimizing libraries Regenerating library entries Rebuilding workspaces and…
Modifying SQL SELECT statements – PB Docs 125
Modifying SQL SELECT statements If the data source is SQL (such as Quick Select, SQL Select, or Query), you can graphically modify the SQL SELECT statement. To modify a SQL data source: Select Design>Data Source from the menu bar. PowerBuilder returns you to the SQL Select painter. (If you used Quick Select to define the…