August 8, 2000

DevX - Software Development Resource

Error Handling Routines

Question: While converting source code from C to C++, I came up with difficulties in converting error handling routines like err_quit(),err_sys(),etc. Are there C++ versions of these functions and where

DevX - Software Development Resource

NT Backup While Exchange Is Running

Question: Can I use NT Backup to get a complete backup of PRIV.EDB and PUB.EDB while Exchange is running? Answer: NT Backup is Exchange-aware so you do not need to

DevX - Software Development Resource

Creating Tables in a Stored Procedure

Question: Can I create a table in a stored procedure named from a parameter? Answer: You can dynamically create tables with variables, but you need to create a string and

DevX - Software Development Resource

Counting Duplicate Rows

Question: How do I count the number of duplicate items in a table? Answer: Lets break down your question into several steps.First, let’s create a sample table using the following

DevX - Software Development Resource

Distribution List E-mail Stuck in Outbox

Question: When I try to send e-mail to the distribution list, it gets stuck in outbox. What should I do? Answer: I’d start by verifying that all of the addresses

DevX - Software Development Resource

Listing Available Tables

Question: How do I list the available tables in a database I’m querying? Answer: You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like

DevX - Software Development Resource

Software Required to Make ASPs

Question: Which software is required for Active Server Pages development? Answer: Internet Information Server (IIS) is the most common way to implement ASP, but there are other plug-ins available for

DevX - Software Development Resource

System.exit(0)

Question: Most GUI examples show System.exit(0) as the window closing eventhandler. However, System.exit(0) is a bad way to exit applications.The specification says that the VM will exit when all the

DevX - Software Development Resource

ALTER TABLE Command

Question: I’ve archived/purged a few thousand rows of unnecessary data, but the disk space reading hasn’t changed. Do I need to use the ALTER TABLE command to reclaim empty space