Tip Bank

DevX - Software Development Resource

ALTER TABLE Command

Question: I’ve archived/purged a few thousand rows of unnecessary data, but the disk space reading hasn’t changed. Do I need to use the ALTER TABLE command to reclaim empty space

DevX - Software Development Resource

Outlook Meeting Requests

Question: Is there a way to turn off meeting requests for a user? Is there a way to turn off the “feature” that sets a tentative meeting when you open

DevX - Software Development Resource

Escaped Characters

Question: When defining a string, is there a way to include a carriage return in the text? Answer: Yes. A carriage return is represented by the special escapedcharacter . However,

DevX - Software Development Resource

Synchronized Method Overhead

Question: I am interested in keeping my code running as fast as possible. Is there a cost associated with making my methods synchronized, and if so, how significant a cost?

DevX - Software Development Resource

Use “.equals” in Place of “==”

Java provides two methods to test for equality: the == Operator and the .equals method. The .equals is implemented by all objects. Most programmers tend to use == for equality,

DevX - Software Development Resource

EnumRASEntries – Enumerate all available RAS phone-book entries

Const ERROR_SUCCESS = 0&Const ERROR_BUFFER_TOO_SMALL = 603&Const RAS_MaxEntryName = 256Private Type RASENTRYNAME dwSize As Long szEntryName(RAS_MaxEntryName) As ByteEnd TypePrivate Declare Function RasEnumEntries Lib “RasApi32.DLL” Alias _ “RasEnumEntriesA” (ByVal reserved As

DevX - Software Development Resource

An enhanced VB DatePart function

Here is an enhanced version of VB DatePart function: the first parameter is now an enumerated type, so easier to use. DatePartEx is 4-5 times faster than DatePart and supports

DevX - Software Development Resource

Check whether RAS is installed

When you work with RAS APIs, you should have to make sure if RAS library is installed on the system. A simple way is to verify the existence of the