Tip Bank

DevX - Software Development Resource

Create Folders Using the File Sytem Object Model

Creating folders with the file system object model can help eliminate errors and long folder-existence checks?especially if you are attempting to create already existing folders. Dim fso as new FileSystemObjectDim

DevX - Software Development Resource

Build Output Using the Ant <tstamp/> Task

When you execute , it generates the local ANT macros ${TSTAMP} and ${DSTAMP}. These are the time and date as numeric strings. They can then be used to dynamically generate

DevX - Software Development Resource

Dynamically Create a Sortable Column

Sometimes you need your resultset sorted a particular way and using the primary key doesn’t accomplish what you need. One way to get around this is to create a sortable

DevX - Software Development Resource

A SQL Split Function

This SQL function is similar to the VB split function. It takes a nvarchar delimeted list and delimeter and returns a table with the values split on delimeter. if exists

DevX - Software Development Resource

Funk Up Your Forms with Fading

I find this particularly useful in an MDI environment where you don’t want to keep switching forms to read information?just make the front form transparent to read the one behind,

DevX - Software Development Resource

Creating and Managing Global Variables

Sometimes, you can’t avoid declaring global variables in C++. However, should you prefer not to mix C++ with C code techniques, try the following: Create a global class and add

DevX - Software Development Resource

Get Details of the Aggregated Data

Say you want to get the latest processes running on Microsoft® SQL Server and their time, hostname, and the username. The following query retrieves this data: Use MasterSelect SysPro1.program_name,SysPro1.login_time,SysPro1.MemUsage,SysPro1.Hostname,SysPro1.Hostname,SysPro1.nt_domain,SysPro1.nt_usernameFrom sysprocesses

DevX - Software Development Resource

Register ActiveX Files Using the Mouse

Do you find yourself constantly registering and unregistering ActiveX .exe, .dll, .ocx, or .olb files? This script allows you to do so with just a mouse click. Here’s how to