Question: When rebuiling indexes I receive an error. Error 1501:[SQL Server] Sort Failure What is happening, and what do I need to do to fix this problem? Answer: I was

Question: How can I program the NT Command Scheduler (AT command) using VB5? What are the API calls? Right now I’m just using Shell to run AT. Is this my

Question: Can you import Excel files into SQL Server tables using bcp? if so what is the command line? Answer: You can’t execute bcp directly against an Excel file. However,

Question: As part of a normal Visual Studio 6 upgrade on an NT Server 4.0 SP3 machine, Setup rebooted the machine “to continue the install.” I then got a blue

Question: I set the usri3_home_dir and home_dir_drive when I create an NT account using VB code. I also need to create the home directory on a specified NT server. Any

Using Active Server Pages, you can easily get the values of fields on a form to display on another Web page for user validation as a simple confirmation page. In

The standard class string (unlike MFC CString for example) doesn’t have a char * conversion operator for two reasons. First, implicit conversions can cause undesirable surprises when you least expect

You can pass information via the URL very easily. This process is called passing information via the Query String. The Query String is the bit of information that is on

Java makes exception handling a piece of cake compared to the exception handling mechanisms in languages like C++. Exceptions in Java are mostly managed by the runtime environment and do

Ever since browsers started multiplying, Web designers have wanted to take advantage of new capabilities without breaking the page for users of older browsers. To use image rollover effects safely,

The Singleton pattern ensures that only one instance of an object is instantiated at run time and that this instance is accessible from a well-known access point. You can change

Question: We are using Visual Basic 6.0 Enterprise, Remote Data Services (RDS) 2.0, Internet Explorer (IE) 4.0, Internet Information Server (IIS) 4.0, and Secure Socket Layer(SSL) 3.0. In RDS 2.0,

Question: I am looking for a way to get a telephone number off an ISDN card and into a Visual Basic 5.0 application. Can you help me? If you can’t

When defining a style with multiple font properties, you can save space and enhance readability by collapsing the font attribute values into a concise notation. A restriction of using this

The Web has long provided a way to embed an e-mail address in a clickable link with the mailto: tag. However it didn’t take long for spammers to develop robots

Web authors have come to depend on HTML entities (those strings that begin with & and end with ;) to represent special characters (from ISO 8859-1 Latin-1). Microsoft Internet Explorer

To squeeze maximum efficiency out of Internet Information Server (IIS) 4.0, you may want to look at the amount of cache provided to each ASP thread. The default value for

Java provides a construct that offers functionality similar to inline functions in C++. In Java, this feature is provided by static intializers. Static initializers are blocks of code within a

Designing a class for an application involves identifying and defining its behavior and state. The behavior is defined in the form of methods that the class provides. Often, in the

If you set the ListIndex property of a list-box or combo-box control, VB might generate an unwanted Click event. Instead of writing code to bypass the Click event, use SendMessage

To explicitly erase the contents of a string object, you can use the member function erase(): void f(){ char key; string msg = “press any key to continue”; cout

Many VB programmers use the Option Explicit statement to make sure each variable has been explicitly declared before using it. This means you’ll always notice a misspelled variable, which if

If your app uses temporary files, store the file name(s) in the Registry as you create them. When you exit the program, delete the temporary file and its related Registry

You can access the topmost element (the one pushed the latest) of a stack container by using the member function top(): #include #include #include using namespace std;void main() { stack

This code creates a smart input box. Every time you type something into this text box, the first letters of your string are compared against the members of a hidden

By default, iostream objects display bool variables as 0 and 1. You can override the default setting by inserting the formatting flag boolalpha to the object stream. Consequently, the symbolic

The operator dynamic_cast comes in two flavors: one uses pointers and the other uses references. Accordingly, dynamic_cast returns a pointer or a reference of the desired type when it succeeds.

You’ve probably noticed that the display time stops when an application pops up VB’s built-in MsgBox. Although the system timer continues to tick, the timer control isn’t updated every second,

You can simplify Win32 APIs by using enumerated types instead of constants. When you use enumerated types, VB provides you with a list of values when you define the API

Reflection plays an essential role in adding dynamism to Java. Using reflection, an application can dynamically (i.e., at run time) determine the state and behavior of any class. Reflection allows