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
Feature Control in Internet Explorer
Feature Control in Internet Explorer Recent versions of Internet Explorer introduce yet another collection of registry settings. This batch are called feature controls. They are in general boolean, such that evaluation as true means that the corresponding feature, which is often some kind of restriction or prohibition, is enabled. As …. Continue Reading »
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 »
Multiple-Choice Questions About Powerbuilder Part 1
Multiple-Choice Questions About Powerbuilder Question: 1 Which of the following variable equals 10? Answer real a = 10 double a = 10.0001 decimal a = 10.09 long a= 10.3 int a = 9.5 Question: 2 Which of the options are available in crosstab? Answer Stored Procedure Update Update properties Retrieve …. Continue Reading »
PowerBuilder API Document
Powerbuilder DataWindow Script Techniques
Powerbuilder DataWindow Script Techniques How do I set a property for an entire column? How many rows selected? How do I check the name of the DataWindow? Putting a Help button on a DataWindow dialog box DataWindow dialog boxes, such as the ones which may come up for Sort( ) …. Continue Reading »
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 »
46 Tips and Tricks Of PowerBuilder Datawindow
1. How to make the column of the stored file directory display pictures? Answer: Select the display as picture property of the corresponding column to be true 2. How to copy the data of the selected row of grid type to the system clipboard? Answer:
|
1 2 3 |
string ls_selected ls_selected = dw_1.Object.DataWindow.Selected.Data clipbord (ls_selected) |
3: How to change …. Continue Reading »
Users Today : 81
Users Yesterday : 152
This Month : 4505
This Year : 11567
Total Users : 150940
Views Today : 180
Total views : 608150
Who's Online : 10