Home Page

  

Computers

 

Databases

Python

 

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 folder.

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 this point.

 

 

SendKeys application

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 other applications.

Some useful API functions:

FindWindow, SetForegroundWindow, SendMessage, GetWindowText

 

top

NT Variables

NT system variables: (or check articles here and here)

ALLUSERSPROFILE Local returns the location of the All Users Profile.
APPDATA Local returns the location where applications store data by default.
CD Local returns the current directory string.
CMDCMDLINE Local returns the exact command line used to start the current cmd.exe.
CMDEXTVERSION System returns the version number of the current Command Processor Extensions.
COMPUTERNAME System returns the name of the computer.
COMSPEC System returns the exact path to the command shell executable.
DATE 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.
ERRORLEVEL System returns the error code of the most recently used command. A non-0 value usually indicates an error.
HOMEDRIVE 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.
HOMEPATH 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.
HOMESHARE 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.
LOGONSEVER Local returns the name of the domain controller that validated the current logon session.
NUMBER_OF_PROCESSORS System specifies the number of processors installed on the computer.
OS System returns the OS name. Windows XP and Windows 2000 display the OS as Windows_NT.
PATH System specifies the search path for executable files.
PATHEXT System returns a list of the file extensions that the OS considers to be executable.
PROCESSOR_ARCHITECTURE System returns the processor's chip architecture. Values: x86, IA64.
PROCESSOR_IDENTFIER System returns a description of the processor.
PROCESSOR_LEVEL System returns the model number of the computer's processor.
PROCESSOR_REVISION System returns the revision number of the processor.
PROMPT Local returns the command-prompt settings for the current interpreter. Cmd.exe generates this variable.
RANDOM System returns a random decimal number between 0 and 32767. Cmd.exe generates this variable.
SYSTEMDRIVE System returns the drive containing the Windows root directory (i.e., the system root).
SYSTEMROOT 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.
TIME 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.
USERDOMAIN Local returns the name of the domain that contains the user's account.
USERNAME Local returns the name of the user currently logged on.
USERPROFILE Local returns the location of the profile for the current user.
WINDIR System returns the location of the OS directory

variable syntax: %variablename%
Batch file (DOS prompt) variables from the command line: %1

 

top

JMBG

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

 

VMWare Tips

2006-08-29: There are three network adapters available at the virtual machine.

To use host-only connection to the host computer the DHCP service must be running.