With the help of West Wind's wwDotNetBridge, you can easily have access .NET code within a VFP program.
The white paper has all the details, but this concise example will help illustrate the basic steps to running a method in a .NET assembly.
Note that wwDotNetBridge can directly access simple pro...
Once you have SCons running, create a file named SConstruct:
print('..Building World')
Now run scons:
$ scons
scons: Reading SConscript files ...
..Building World
scons: done reading SConscript files.
scons: Building targets ...
scons: `.' is up to date.
scons: done building targets.
S...
If you have modifications to share or just want to try new version in development.
$ hg clone https://bitbucket.org/scons/scons
$ python scons/src/script/scons.py
In this example you will be modifying the Marital Status drop-down list found on the Contacts form (CR302000):
To add new items to the PXStringListAttribute successor
The best way to extend drop-down items hard-coded inside an attribute inherited from the PXStringList or PXIntList attribute is b...
There are some situations where you won't be sure what type a variable is when it is returned from a function. You can always check a variable's type by using var.(type) if you are unsure what type it is:
x := someFunction() // Some value of an unknown type is stored in x now
switch x := x.(type...
This workaround helped us so much at my job (Tech Support), we made a simple batch file we could run from anywhere (We didnt have the permissions to install the actual exe). This workaround will run OpenSSL and open up the bin folder for you (cause this is where any files you create or modify will b...
/* these IN and OUT filerefs can point to anything */
filename in "anyfilehere.xlsx";
filename out "anyfilehere.xlsx";
/* copy the file byte-for-byte */
data _null_;
length filein 8 fileid 8;
filein = fopen('in','I',1,'B');
fileid = fopen('out','O',1,'B');
...
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'Text/Plain';
Data _null_; File myEmail;
PUT "Email content";
PUT &q...
Take note of the email type: Type = 'text/html';
Filename myEmail EMAIL
Subject = "My Email Subject"
From = "[email protected]"
To = '[email protected]'
CC = '[email protected]'
Type = 'text/html';
Data _null_; File my...
This example shows how to manipulate button ideal size by specifying a fixed size.
class ButtonSubclass {
public:
ButtonSubclass(HWND hWndButton) {
SetWindowSubclass(hWndButton, MyButtonSubclassProc, 1, (DWORD_PTR) this);
}
~ButtonSuclass() {
RemoveWindowSubclass...
There will be times where you only want to import a specific sheet from an excel file with multiple sheets. To do that, we'll use "SHEET=".
PROC IMPORT
OUT= YourNewTable
DATAFILE= "myfolder/excelfilename.xlsx"
DBMS=xlsx
REPLACE;
SHEET="Sheet1&quo...
pip install scons
If you are not to run scons from command line, check that Python scripts directory is added to PATH for your installation.
If you want to play with API, import SCons from Python won't work, because SCons 2.5.x and below allows to install multiple versions side-by-side. This was...
I would describe %LET as being the most simple way to creating a Macro Variable in SAS.
%LET variableName = variableValue;
Now, anywhere you use &variableName, it will resolve to variableValue.
NOTE:you may want to consider that variableValue all on its own might bring you syntax errors, ...
Using PROC SQL is a good way to get quick results from a table and throw them into variables. I usually find that when I want to get a count of records I just loaded to a table, I can get that count into a variable with a quick PROC SQL call.
PROC SQL;
SELECT
COUNT(*) INTO:aVariable
FROM
...
