‘ Returns a collection with the names of all the executable’ files in a directory or a directory tree’ this includes all “exe”, “bat”, “com”, “pif” files” NOTE: Uses the

Option ExplicitPrivate Declare Function FindFirstFile Lib “kernel32” Alias “FindFirstFileA” _ (ByVal lpFileName As String, lpFindFileData As WIN32_FIND_DATA) As LongPrivate Declare Function FindNextFile Lib “kernel32” Alias “FindNextFileA” _ (ByVal hFindFile As

At times you may need to create a GUID from ASP, for example when assigning unique IDs to users that are visiting your site for the first time. While you

Private Enum CommandOpConstants cocStart = 1 cocStop cocPause cocContinueEnd Enum’ Start, Stop, Pause or Continue a service using Active Directory’ Returns True if successful” NOTE: requires a reference to the

Const MAX_MODULE_NAmeInfo = 255Const MAX_PATH = 260Const TH32CS_SNAPMODULE = &H8Private Type MODULEENTRY32 dwSize As Long th32ModuleID As Long th32ProcessID As Long GlblcntUsage As Long ProccntUsage As Long modBaseAddr As Long

Const MAX_PATH As Long = 260Private Type PROCESSENTRY32 dwSize As Long cntUsage As Long th32ProcessID As Long th32DefaultHeapID As Long th32ModuleID As Long cntThreads As Long th32ParentProcessID As Long pcPriClassBase

‘ Get the names of all the installed Windows GetServiceNames using Active ‘ Directory” if you pass True, the display names are returned’ otherwise the internal names are returned’ (internal

‘ Copy a file’s contents into a BLOB field.Sub FileToBlob(fld As ADODB.Field, filename As String, _ Optional ChunkSize As Long = 8192) Dim fnum As Integer, bytesLeft As Long, bytes

‘ return the list of US States and their abbreviations” returns a bi-dimensional array organized in this way’ res(n, 0) holds the state’s name’ res(n, 1) holds the state’s abbreviation’

The standard way to create a UDL file is to right-click in the directory where you want to create it and select the New-Microsoft Data Link menu command. Unfortunately, on

‘ Copy the field structure of a Recordset to a new Recordset.” The original code has been improved to account for Numeric and Decimal’ fields, that also require the setting

‘ Copy a BLOB field’s contents to a binary file.Sub BlobToFile(fld As ADODB.Field, filename As String, _ Optional ChunkSize As Long = 8192) Dim fnum As Integer, bytesLeft As Long,

When a class has Thread entry functions, it is usually declared as static member functions of the class as in the example below: Class A{private: int i,j,k;public: //Thread Entry function

Suppose you have a thread function ThreadFunc in a class CMyClass and you want to access a member of that class. Here’s what to do: Declare the thread function as

#include void main(){ char cBuf[96]; float fVar=5.678; int nVar=78; //Conversion from float to char* sprintf(cBuf,

Let’s start with a code fragment: Statement stmt;Connection con;Class.forName(

Many times in DB programming, a situation occurs when one operation, depends on the result of the other, but there is no way to communicate that result to the first

It’s common when working with dates to be able to determine the last date of a particular month. I’ve seen solutions to this problem that range from using arrays or

When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an unreadable form.

Using the WITH ENCRYPTION clause when creating views ensures that they remain secure by keeping the view definition hidden. Sample code:————— Create view Procedure ————–create view

Beginners and even experienced programmers who switch to a new compiler suddenly discover that their programs don’t compile anymore. Sometimes the programs compile but produce numerous warning messages. In most

Don’t forget that MS compiler initiates pointers with 0xCCCCCCCC value. In this case: void *p; … //do something here… if (p!=NULL) delete p; // Memory violation The right way void*

The sprintf() function isn’t type-safe, it doesn’t support user-defined types and it’s a common source of buffer overflow bugs. In C++, there’s a better alternative to sprintf(), namely stringstream objects.

Sizeof is a useful operator because it reports both the amount of memory that data items take and the number of bytes that data types. For instance: cout

It is unfortunate that VB5 does not provide a quick way to check if an item with a certain key exists in a collection. This results in errors if an

This is a fast, efficient way to make a split function. For longer strings, performance can be improved by enlarging AllocUnits. Public Function Split(strText As String, _Optional Byval Delimited As