This page is supposed to be the internet center for my development efforts.
2006-10-23 - Added Databases page after
installing SQL Everywhere.
Aug 8, 2004 - 2p IBRepl package. Available for free download. After
installing, you need to register and receive the activation key. The process is
automatic and pretty painless. UDF library needs to be copied to Firebird\UDF
On Jul 27, 2004, I did a test of Open Source and free
RDBMS and posted the page on this site. Since the features tests are
becoming a routine, because of the need to compare the enterprise features, the
page with tests will be updated when the tests are redone.
During this testing, I wrote down the detailed instructions on
how to install Postgres on Windows.
Initially, this was supposed to explain how to install Postgres under Cygwin,
the solution I used before, but it did not work this time. So, the above page
contains links to Postgres port for Windows, which is in development stage at
SendKeys is used to emulate typing characters to an application. In
dotNet framework there is a class SendKeys that is used for this purpose. It
is recommended to use native Windows methods, such as FindWindow
and/or SetForegroundWindow to transfer the focus to
Some useful API functions:
FindWindow, SetForegroundWindow, SendMessage, GetWindowText
NT system variables: (or check articles
here and here)
||Local returns the location of the All Users Profile.
||Local returns the location where applications store data by
||Local returns the current directory string.
||Local returns the exact command line used to start the
||System returns the version number of the current Command
||System returns the name of the computer.
||System returns the exact path to the command shell
||System returns the current date. This variable uses the same
format as the date /t command. Cmd.exe generates this variable. For more
information about the date command, see the Date command.
||System returns the error code of the most recently used
command. A non-0 value usually indicates an error.
||System returns which local workstation drive letter is
connected to the user's home directory. This variable is set based on the
value of the home directory. The user's home directory is specified in Local
Users and Groups.
||System returns the full path of the user's home directory.
This variable is set based on the value of the home directory. The user's
home directory is specified in Local Users and Groups.
||System returns the network path to the user's shared home
directory. This variable is set based on the value of the home directory.
The user's home directory is specified in Local Users and Groups.
||Local returns the name of the domain controller that
validated the current logon session.
||System specifies the number of processors installed on the
||System returns the OS name. Windows XP and Windows 2000
display the OS as Windows_NT.
||System specifies the search path for executable files.
||System returns a list of the file extensions that the OS
considers to be executable.
||System returns the processor's chip architecture. Values:
||System returns a description of the processor.
||System returns the model number of the computer's processor.
||System returns the revision number of the processor.
||Local returns the command-prompt settings for the current
interpreter. Cmd.exe generates this variable.
||System returns a random decimal number between 0 and 32767.
Cmd.exe generates this variable.
||System returns the drive containing the Windows root
directory (i.e., the system root).
||System returns the location of the Windows root directory.
|TEMP or TMP
||System and User return the default temporary directories for
applications that are available to users who are currently logged on. Some
applications require TEMP and others require TMP.
||System returns the current time. This variable uses the same
format as the time /t command. Cmd.exe generates this variable. For more
information about the time command, see the Time command.
||Local returns the name of the domain that contains the
||Local returns the name of the user currently logged on.
||Local returns the location of the profile for the current
||System returns the location of the OS directory
variable syntax: %variablename%
Batch file (DOS prompt) variables from the command line: %1
The following is the code that checks the validity of the Bosnian JMBG
(id) according to mod 11:
If (Left(P, 1) * 7 + Mid(P, 2, 1) * 6 + Mid(P, 3, 1) * 5 + Mid(P, 4, 1)
* 4 + Mid(P, 5, 1) * 3 + Mid(P, 6, 1) * 2 + Mid(P, 7, 1) * 7 + Mid(P, 8, 1)
* 6 + Mid(P, 9, 1) * 5 + Mid(P, 10, 1) * 4 + Mid(P, 11, 1) * 3 + Mid(P, 12,
1) * 2 + Mid(P, 13)) Mod 11 = 0 Then IsValid = True
2006-08-29: There are three network adapters available at the virtual
To use host-only connection to the host computer the DHCP service must be