Here are functions to perform decimal to/from binary conversion. CBin – converts a decimal integer to binary string. CDeci – converts a binary string to decimal integer. CBinS16 – converts a decimal signed integer to 16 bit binary string. CdecS16 – converts a 16 bit binary string to decimal signed integer.

Having to parse huge amounts of data from xml files to an SQL Server database, I needed to greatly optimise my code. Here are some tests to insert 10000 rows into table TABLETESTER. First, using the standard INSERT INTO without specifying column names. TickCount of 70547. Specifying the column names is actually marginally faster. TickCount…

When you are parsing large amounts of data, the way you code string matching can make a huge difference. In one case I needed to find if a string was contained within quotes, here are the test results from quickest to slowest. The test situation was to find if the last character in the string…

Here is an implementation of Base 36 enconding/decoding functions is VB6.

If you received this error when trying to execute eventquery.vbs the cause is an overflow of events past 32,767 (the maximum capacity of a VB6 Integer). There is a very simple fix for this which is to change the data type from an Integer to a Long (which has a maximum capacity of 2,147,483,647). In…

Here’s a current list of Foundation Fieldbus unit enumerations extracted from the freely available DD files. foundation-fieldbus-list-of-unit-enumerations.txt

Recently updated and confirmed still working with WordPress 3.0. The following examples use the included example.xml file. Marker Z – no HTML, nonclickable. Marker 1 – standard maker with some text. Marker Default – no icon defaults to standard Google Maps marker. Marker $ – some symbols can even be displayed on a marker and…

For information only, How to Unlock Garmin maps. First get your hands on the desired Garmin City Navigator Downloadable Update for your country/city (MapSource A). In the compressed file should be the folders IMG, support and Windows plus a readme.txt. You will need a version of Garmin MapSource 6.13.1 or older which does NOT support…

Here is a simple tool that might be useful to others, it does two main things; Parses your post’s content as XML and spits out any possible errors, and Extracts all external links, which can be exported as an Excel Tab delimited file. Post’s content errors Each post’s content is wrapped with XML dummy tags…

8 Suits, as you guessed is a deck of playing cards with an additional 4 suits, the clover, tear, crescent and star for a total of 104 cards plus a number of jokers. Priced at $12 USD per deck plus $5 per postage ($13 per postage internationally), it is a little steeper than The Fat…