All statements executed in a stored procedure, including SELECT statements, generate an “x rows affected” message. These messages are typically not needed by the application when it is executing a

In ANSI SQL, you are always in a transaction, because there is no BEGIN TRANSACTION statement. The purpose of the SET IMPLICIT_TRANSACTIONS command in SQL 7.0 is to allow T-SQL

JavaScript has both numeric and string types, and it converts between these as it encounters them in the script. It uses “+” for both numeric addition as well as string

Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below

You cannot include a comment in an output expression while working with server side scripts. For example, the first line that follows will work, but the second line will not,

To quickly establish a database connection from ASP, try using a file DSN. The DSN string should not contain spaces, either, before or after the equal sign (=). In this

Running isolated ASP applications in a separate memory space from the Web server has another advantage besides protecting other ASP applications and the Web server from failing in case the

Although the Dictionary object does not have an enumerator, it does have an Items method that returns a Variant array. You can use the For…Each construct on the array: Dim

Microsoft’s Internet Transfer Control (MSInet.ocx) is a great tool to use to automate the Web. However, how do you know you’re looking at an updated version of a Web page?

The IIf function-which returns one of two values determined by logical test-has this syntax: IIf(Expression, TruePart, FalsePart). At first, it might seem like an ideal shortcut for an If…Else…End If

To create a collection class you can use with the For Each…Next syntax, add a subroutine that looks like this: Private myCollection As CollectionPublic Property Get NewEnum() As IUnknown Set

You can easily customize the fonts and colors in individual statusbar panels using a PictureBox control and an API call. Each statusbar panel can display a Picture object, so you

Many routines use the SetWindowPos API to always keep a form on top. Most require the user to remember several nonintuitive arguments. I’ll not only show you how to simplify

It’s often faster to perform string operations with byte arrays than with 32-bit VB’s native double-byte character strings. Even when using 16-bit VB4’s single-byte character strings, it’s still often faster

The Media Control Interface (MCI) can easily support multiple CD audio devices.You simply specify the drive letter in the MCI open command. To eject the CD from any drive,first place

I have read many tips about using MouseMove events to create an Explorer-like coolbar look. The problem is that if your button is located close to the main form’s border

VB provides an easy way to access the Registry with the built-in GetSetting and SaveSetting functions. These functions read and write information to the HKEY_CURRENT_USERSoftwareVB and VBA Program area of

Call this sub to insert text of any color at the current insert point of a RichTextBox: Private Sub ColorText(rtb As RichTextBox, Color _ As Long, Text As String) Dim

VB6’s Setup Wizard generates gradient blue background screens, as do wizards in previous versions of VB. However, an undocumented setting gives you the opportunity to see installation programs with other

I keep all my projects in a particular directory such as C:work. When I save or open up a new project, I want the File dialog box to start at

Windows doesn’t treat comments in INI files the same way VB does in code. Typically, comments must be on a single line of their own. When calling the GetPrivateProfileString function,

If you use variable-length strings and/or dynamic arrays in a user-defined type (UDT), the actual data does not become part of the structure. Instead, four-byte pointers are stored in the

To blank out the text in a masked edit box, make sure the string you assign uses underscores matching the mask. It’s difficult to maintain code when you have to

Examine this code snippet. Will your compiler accept it? void a_func_returning_void();void func(){ return a_func_returning_void(); //returning a value from a void function?} At present, most compilers will not accept this code

The following link ranks several popular C++ compilers according to their ANSI/ISO compliance level. The comparison chart contains various features such as exported templates, Runtime Type Information, Koenig lookup, explicit

Dev-C++ is a free graphical C++ compiler for Windows 95, 98 and NT. You can download it for free from: http://www.bloodshed.net/devcpp.htmlThe Dev-C++ package also includes a debugger and source file

The GNU project focuses on the development and distribution of open source software, including free compilers. The newly-released GCC 2.95 is a free C/C++ compiler. GCC 2.95 includes nearly a

The C++ exception handling model is non-resumptive. In a resumptive model, after an exception has been handled, the program continues execution at the point where the exception was thrown. In