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...
Datapump jobs can be monitored using
1. data dictionary views:
select * from dba_datapump_jobs;
SELECT * FROM DBA_DATAPUMP_SESSIONS;
select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'bkpadmin';
2. Datapump status:
Note down the j...
Source Server [Export Data]Target Server [Import Data]1. Create a datapump folder that will contain the export dump files4. Create a datapump folder that will contain the import dump files2. Login to database schema that will perform the export.5. Login to database schema that will perform the impor...
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...
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...
First, I will place my date into a Macro Variable.
NOTE: I find that
date9. works great with IBM® Netezza® SQL and Transact-SQL. Use whichever format that works for the type of SQL you're executing.
data _null_;
call symput('testDate',COMPRESS(put(today(),date9.)));
;RUN;
%PUT ...
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...
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
...
DATA _null_;
CALL SYMPUT('testVariable','testValueText');
;RUN;
In the example above, %PUT &testVariable; will resolve to testvalueText.
You may find the need to format your variable within the SYMPUT() call.
DATA _null_;
CALL SYMPUT('testDate',COMPRESS(PUT(today(...
A frequent question about StackViews inside Scrollviews comes from ambiguous with/heigh alerts on interface builder. As this answer explained, it is necessary to:
Add in the UIScrollView a UIView (the contentScrollView);
In this contentScrollView, set top, bottom, left and right margins to 0
Se...
LINQ queries do not execute immediately. When you are building the query you are simply storing the query for future execution. Only when you actually request to iterate the query is the query executed (e.g. in a for loop, when calling ToList, Count, Max, Average, First, etc.)
This is considered de...
