Everyone can deal with one recordset easily. However, if a SQL statement is like this: “SELECT a, b FROM Table1 COMPUTER SUM(a), SUM(b),” looping though the recordset will not return

To change the case of all the letters in a string object, use the std::transform() algorithm. This algorithm is defined in the standard header . It takes four arguments. The

Many programmers append the endl manipulator after each cout expression, as in: cout

The standard streams cin and cout are automatically tied to each other. This means that whenever you’re using both of them, C++ ensures that their operation is synchronized. In other

The standard stream objects support all built-in types as well as several classes of the Standard Library, e.g., std::string. If you’re using complex arithmetic, you’d be pleased to hear that

Classes having a non-virtual destructor aren’t meant to be derived from (such classes are usually known as “concrete classes”). std::string, std::complex, and all STL containers are concrete classes. Why is

Question: How can I release all existing database locks for all the sessions a specific user has started? Answer: The easiest way probably is to log that user out. Otherwise,

Question: I have been receiving the following (albeit general) error sporadically: “Microsoft OLE DB Provider for ODBC Driverserror ‘80004005’ [Informix][Informix ODBC Driver]General error.” This error has occurred when the code

Question: I have a parameterized SQL statement like the following: “insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES(?,?,?)” It’s parameters are ‘bbb’,’name’ and ‘2000/01/01 22:23:25′, using an ODBC connection. I can’t

Question: Outbound messages are being delayed randomly. You can send them to the same host—sometimes they don’t queue up long enough to even see. Other times they are there for

Question: Is there a command-line way to back up my Exchange databases without stopping the services, like the GUI can? Or, for that matter, is there any automated method of

The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a

Question: What is the purpose of using the fetch and declare cursor in Informix.4GL?How do you use the scroll cursor, and what are its advantages? Answer: Cursors allow you to

Question: My ace report/shell script did not wait for user intervention. I have solved that with: script.sh < mytty > mytty But now the screen needs refreshing with a CTRL-R.

Question: How can I place my Exchange Server on a network with private addresses and have my MX record point to the server even though the server is behind a

Question: I have a Windows 2000 server where I have installed the Exchange Server 5.5 Service Pack 3. I want to do a backup, but the Exchange option is empty

Question: How can I redirect mail sent to a particular mailbox to an external address? Answer: Outlook 2000 has the ability, in the Rules Wizard, to redirect mail. You’ll find

Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT

Question: I have about 50 users on an “old” Exchange Server (version 5.0 SP2), and I need to move them to a new server. The problem is that the new

Question: This weekend I did a restore of my Information store. I had to do a repairmidway through. This morning, a few people have told me they can’t opensome mail

I came across this solution while trying to embed an applet in an XSL page I was using to transform my XML source document into HTML.If you want to cut

Private Declare Function FindWindow Lib “user32” Alias “FindWindowA” (ByVal _ lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SendMessage Lib “user32” Alias “SendMessageA” (ByVal _ hwnd

‘ Returns an array and initializes it with passed data.” It is similar to the Array function, but it works with’ array of any type. The type of the returned

Many VB developers use a class module to augment the capabilities of a control on a form. For example, consider this simple example, that formats a currency value in a

If you want to execute an application and waiting for its termination, you can follow two approaches. The “classic” approach is based on API functions such as OpenProcess, WaitForSingleObject and

You can retrieve the length of a standard windows media file (WAV, AVI or MIDI) using simple MCI functions. First, you must open the file with: Declare Function mciSendString Lib

The simplest way to help user copy a floppy disk is display the Copy Disk system dialog. You can do this with a one-line statement: Shell “rundll32.exe diskcopy.dll,DiskCopyRunDll 0,0”

Private Declare Function GetDesktopWindow Lib “user32” () As LongPrivate Declare Function GetDC Lib “user32” (ByVal hWnd As Long) As LongPrivate Declare Function ReleaseDC Lib “user32” (ByVal hWnd As Long, _

Question: I’m working with ASP to retrieve records, but I keep getting an “Unexpected Error” near my recordset function. Why? Answer: Pinpointing exactly what’s wrong would be hard without actually

Question: What is the best Backup Software available that will do a live backup of the Exchange Information Stores? Answer: I haven’t evaluated all of them, but we’ve been satisfied