Controlling comments – PB Docs 126
Controlling comments By default, PowerBuilder strips off comments when it sends SQL to the DBMS. You can have comments included by clearing the check mark next to Strip Comments in the pop-up menu of the Interactive SQL view. Document get from Powerbuilder help Thank you for watching.
Using AutoScript – PB Docs 126
Using AutoScript AutoScript is a tool designed to help you write PowerScript code more quickly by providing a lookup and paste service inside the Script view. It is an alternative to using the paste toolbar buttons or the Browser—you do not need to move your hands away from the keyboard to paste functions, events, variables,…
Creating a new table from scratch – PB Docs 126
Creating a new table from scratch In PowerBuilder, you can create a new table in any database to which PowerBuilder is connected. To create a table in the current database: Do one of the following: Click the Create Table button. Right-click in the Columns view and select New Table from the pop-up menu. Right-click Tables…
Managing databases – PB Docs 126
Managing databases PowerBuilder supports many database management systems (DBMSs). For the most part, you work the same way in PowerBuilder for each DBMS, but because each DBMS provides some unique features (which PowerBuilder makes use of), there are some issues that are specific to a particular DBMS. For complete information about using your DBMS, see…
Closing a table – PB Docs 126
Closing a table You can remove a table from a view by selecting Close or Reset View from its pop-up menu. This action only removes the table from the Database painter view. It does not drop (remove) the table from the database. Document get from Powerbuilder help Thank you for watching.
Examples of user object controls affecting a window – PB Docs 126
Examples of user object controls affecting a window To illustrate these techniques, consider a simple custom visual user object, uo_minmax, that contains two buttons, Maximize and Minimize. If the user clicks the Maximize button in an application window containing this user object, the current window becomes maximized. If the user clicks Minimize, the window closes…
Piping blob data – PB Docs 126
Piping blob data Blob data is data that is a binary large-object such as a Microsoft Word document or an Excel spreadsheet. A data pipeline can pipe columns containing blob data. The name of the datatype that supports blob data varies by DBMS. Table 17-5 shows some examples. Table 17-5: Examples of datatypes that support…
About inheritance – PB Docs 126
About inheritance One of the most powerful features of PowerBuilder is inheritance. It enables you to build windows, user objects, and menus that derive from existing objects. Using inheritance has a number of advantages: When you change an ancestor object, the changes are reflected in all the descendants. You do not have to make manual…
Building two windows with similar definitions – PB Docs 126
Building two windows with similar definitions Assume your application needs two windows with similar definitions. One window, w_employee, needs: A title (Employee Data) Text that says Select a file: A drop-down list with a list of available employee files An Open button with a script that opens the selected file in a multiline edit box…
PictureButton – PB Docs 126
PictureButton PictureButtons are identical to CommandButtons in their functionality. The only difference is that you can specify a picture to display on the button. The picture can be a bitmap (BMP) file, a GIF or animated GIF file, a JPEG file, a PNG file, a run-length encoded (RLE) file, or an Aldus–style Windows metafile (WMF)….