PowerScript Syntax for .NET Calls – PB Docs 150
PowerScript Syntax for .NET Calls When you make calls to .NET assemblies or their methods or properties from PowerBuilder, you must follow PowerScript syntax rules. The following syntax rules are especially important for C# developers to keep in mind: Instantiating a class To instantiate a class, use �create�, not �new�. Even when you are referencing…
Creating a DataWindow based on a cross-database join – PB Docs 150
Creating a DataWindow based on a cross-database join The ability to create a DataWindow based on a heterogeneous cross-database join is available through the use of Adaptive Server’s Component Integration Services. Component Integration Services allow you to connect to multiple remote heterogeneous database servers and define multiple proxy tables that reference the tables residing on…
PowerBuilder Windows Forms Applications – PB Docs 150
PowerBuilder Windows Forms Applications PowerBuilder applications with a rich user interface that rely on resources of the client computer, such as a complex MDI design, graphics, or animations, or that perform intensive data entry or require a rapid response time, make good candidates for deployment as Windows Forms applications. Adapting an existing application The changes…
Microsoft SQL Server Transaction management statements – PB Docs 150
Microsoft SQL Server Transaction management statements Transaction management statements You use the following transaction management statements with transaction objects to manage connection and transactions for a SQL Server database: CONNECT COMMIT DISCONNECT ROLLBACK Transaction management in triggers You should not use transaction statements in triggers. A trigger is a special kind of stored procedure that…
SetMask – PB Docs 150
SetMask PowerScript function Description Sets the edit mask and edit mask datatype for an EditMask control. Controls EditMask controls Syntax
|
1 |
<span>editmaskname</span>.<span>SetMask</span> ( <span>maskdatatype</span>, <span>mask</span> ) |
Argument Description editmaskname The name of the EditMask for which you want to specify the edit mask. maskdatatype A MaskDataType enumerated datatype indicating the datatype of the mask. Values are: DateMask! DateTimeMask! DecimalMask! NumericMask!…
Microsoft SQL Server DELETE, INSERT, and UPDATE – PB Docs 150
Microsoft SQL Server DELETE, INSERT, and UPDATE Internally, PowerBuilder processes DELETE, INSERT, and UPDATE statements the same way. PowerBuilder inspects them for any PowerScript data variable references and replaces all such references with a constant that conforms to SQL Server rules for the data type. Example Assume you enter the following statement:
|
1 |
DELETE FROM employee WHERE emp_id = :emp_id_var; |
In this…
Syntax 1 For InkPicture controls – PB Docs 150
Syntax 1 For InkPicture controls Description Saves a picture and optionally overlay ink to a file or blob from an InkPicture control. Controls InkPicture controls Syntax
|
1 |
<span>inkpicname</span>.Save(<span></span> <span>t</span> | <span>b</span> , <span>format </span>{ , <span>WithInk</span> } ) |
Argument Description inkpicname The name of the InkPicture control from which you want to save a picture. t A string containing the name and location of the file into…
Microsoft SQL Server FETCH NEXT – PB Docs 150
Microsoft SQL Server FETCH NEXT In the singleton SELECT, you specify variables to hold the values for the columns within the selected row. The FETCH statement syntax is similar to the syntax of the singleton SELECT. Values are returned INTO a specified list of variables. This example continues the previous example by retrieving some data:…
RecognizeText – PB Docs 150
RecognizeText PowerScript function Description Specifies that text in an InkEdit control should be recognized. Controls InkEdit controls Syntax
|
1 |
<span>inkeditname</span>.<span>RecognizeText</span> (<span></span> ) |
Argument Description inkeditname The name of the InkEdit control in which you want to recognize text. Return Values Integer. Returns 1 if text is recognized and 0 otherwise. Usage By default, ink is recognized automatically when…
Preparing to use the Adaptive Server database – PB Docs 150
Preparing to use the Adaptive Server database Before you define the interface and connect to an Adaptive Server database in PowerBuilder, follow these steps to prepare the database for use: Install and configure the required database server, network, and client software. Install the Adaptive Server database interface. Verify that you can connect to Adaptive Server…