Excel File Format enumeration. Specifies the file format when saving the worksheet. Example Specifies the file format when saving the worksheet. from https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat Name Value Description Extension xlAddIn 18 Microsoft Excel 97-2003 Add-In *.xla xlAddIn8 18 Microsoft Excel 97-2003 Add-In *.xla xlCSV 6 CSV *.csv xlCSVMac 22 Macintosh CSV *.csv …. Continue Reading »
Operation OLEObject Excel Command Powerbuilder
CONSTANT Of Windows API Functions Design
Events List In PowerBuilder
Events List In PowerBuilder Single-select or multiple-select button message (prefix: pbm_bm) pbm_bmgetcheck Whether the radio button or multi-select button is selected. pbm_bmgetstate Whether the button is highlighted. pbm_bmsetcheck Change the selected state of the wireless button or confirmation box to the unselected state, and vice versa. pbm_bmsetstate Highlight or not …. Continue Reading »
Functions Popular In PowerBuilder
Functions Popular In PowerBuilder Functions Popular In PowerBuilder Functions Desctions 1. Data type functions Char : Convert bolb, integer, and string to characters and return Dec : Converts the contents of a string to a decimal number and returns Double : Converts the contents of a string to a Double and returns Integer : …. Continue Reading »
PowerBuilder API Document
Variables In PowerBuilder
Variables In PowerBuilder Arrays Initializing
1 2 | String ls_array[] Ls_array = {"value1", "value2","value3", "value4"} |
Set to Null Array
1 2 3 4 | String ls_arrayofnulls SetNull(ls_arrayofnulls) // … some code that loads values into ls_array[] ls_array = ls_arrayofnulls |
Decimal
1 2 3 4 5 6 7 8 | decimal {4} a,b,d,e,f decimal {3} c a = 20.0/3 // a contains 6.6667 b = 3 * a // b contains 20.0001 c = 3 * a // c contains 20.000 d = 3 * (20.0/3) // d contains 20.0000 e = Truncate(20.0/3, 4) // e contains 6.6666 f = Truncate(20.0/3, 5) // f contains 6.6667 |
Default Values Variable Default Value Blob A blob of 0 length; an empty blob Char (or character) ASCII value 0 Boolean FALSE Date 1900-01-01 (January 1, 1900) DateTime 1900-01-01 00:00:00 Numeric (integer, long, decimal, real, double, UnsignedInteger, …. Continue Reading »
Convert The Datatypes From Microsoft Win API To PowerBuilder
Convert The Datatypes From Microsoft Win API To PowerBuilder MICROSOFT PB(32Bit) Bool Boolean Char* Ref String Colorref Ulong Dword Ulong Handle Ulong Hdc Ulong Hfile Ulong Hinstance Ulong Hwnd Ulong Int Int Lparam Ulong Lpbyte Ref Long Lpdword Ref Ulong Lpfiletime Ref Time Lpint Ref Long Lpstr,Lpststr Ref String Lpvoid …. Continue Reading »
123 Tips & Tricks Of PowerBuilder
Collection PowerBuilder Tips & Tricks. Get From The Internet Tips 1: Changing DataWindow object by code methods Tips 2: Open dynamic window approach Tips 3: Displays a consistent style with the Windows operating system About dialog. First, the following statement external function: Tips 4: How COLUMN display style between EDIT, …. Continue Reading »
Variable Naming Standards In PowerBuilder
Variable Naming Standards In PowerBuilder Variable naming standards for standard variables declared within the Powerscript environment. This includes variables declared in dialog windows such as global and instance variables. The object name should be typed using Camel Case. Camel case is a standard used to aid readability in scripts, the …. Continue Reading »
Users Today : 75
Users Yesterday : 109
This Month : 75
This Year : 28563
Total Users : 214016
Views Today : 290
Total views : 889515
Who's Online : 2