Tip Bank

DevX - Software Development Resource

The Scope of Enumerators

The members of an enumerated type are called enumerators. For example: enum Direction { Up, // an enumerator Down // another enumerator }; int main() {} An enumerator’s scope is

DevX - Software Development Resource

Porting Code to a Different Compiler

I receive many questions from readers asking for guidance on how to port an existing C++ app to a different compiler or platform. Porting software can be very easy or

DevX - Software Development Resource

Accessing an Object From Another Process

On modern operating systems, a process consists of an executable file that the OS loads into the system’s memory and executes. A process normally has an entry point and one

DevX - Software Development Resource

Table Columns

Question: How do I drop a table column? Answer: To drop a column, use this syntax: ALTER TABLE Employees DROP COLUMN HomePhone Just remember that you can’t drop a column

DevX - Software Development Resource

Deadlock Timeouts

Question: I have two questions: 1. How can I determine what the server’s lock mode currently is (e.g. WAIT, NO WAIT, etc.), without actually setting it at the same time?

DevX - Software Development Resource

Visual Basic Data Access, ADO, OLE/DB

Question: What are the differences between Provider=MSDASQL.1 and Provider=SQLOLEDB.1 in an “Open” “Select” statement? Also, what is the difference (if any) between “ADO” AND “OLE/DB”? And finally, in Visual Basic,

DevX - Software Development Resource

uniqueidentifier vs. int

Question: If I have the option of using the uniqueidentifier or int data type for a primary key, will choosing the uniqueidentifier mean a significant performance degradation? Answer: The uniqueidentifier

DevX - Software Development Resource

Getting CGI Output

Question: Using C or C++ for CGI programs, is there a way to make a CGI program that calls another CGI program, and then takes the output of that called