The Latest

DevX - Software Development Resource

Implicit Function Declaration

Question: I am a Computer Science student, and I am trying to compile a program where I use multiple files and my own header file for the first time. But

DevX - Software Development Resource

Eight-Byte Data Types

Question: I am looking for a data type in C++ that takes eight bytes. I have tried long, long int, and so forth, but they are all four bytes on

DevX - Software Development Resource

Debugging Macros

Question: In our project we are using many long macros. How we can debug them (setting breakpoints, etc.)? Is there any solution for that in Visual C++ 6.0? Answer: Unfortunately,

DevX - Software Development Resource

Exporting Templates Under C++

Question: How do I create a template library so that I can export templates and use them in different programs? Answer: I’m not sure I understand what you mean by

DevX - Software Development Resource

Memory Stack vs. Free Store

Question: When using C++, is it better to use stack or free store memory for data objects of medium to large size? I have multiplatform concerns on the answer. The

DevX - Software Development Resource

Initializing a Const Member

Question: I’m trying to initialize a const declared in a class. How do I do this? This example fails: class MyClass {private: const int A;}MyClass::MyClass () { A = 1;}

DevX - Software Development Resource

Templates and Nested Classes

Question: What is the C++ syntax for defining a function that belongs to a nested class that is contained within a template class? For example: template class A{ protected: //

DevX - Software Development Resource

Default String Class

Question: Is there a built-in or default string class in C++ or do I have to create my own? If so, what file can I look in to see the

DevX - Software Development Resource

STL and User-Defined Classes

Question: I’m new to the Standard Template Library. How do I incorporate a user-defined class into a hash_map? What functions do I need to overload? I get compiler errors when

DevX - Software Development Resource

Address of a Constructor

Question: How can I obtain the address of a constructor for a C++ class object? Answer: A constructor is not an ordinary member function. You cannot take its address. Related

DevX - Software Development Resource

Default Arguments to Functions

Question: Is it considered acceptable to use default argument initializers both in a definition of a function (e.g., void foo(int x =10) {…}) as well as its declaration? Stroustrup, in

DevX - Software Development Resource

Linking Two Databases in a SQL Query

Question: I have two databases, each on a separate machine in a network. I want to generate a report extracting data from table1 in database1 and table2 in database2. How

DevX - Software Development Resource

SQL Using Like to Search for

Question: I have created a database of journal articles and want to offer users the ability to search the Author field for the surnames of authors. Most of the articles

DevX - Software Development Resource

Can ADO Read and Write XML Files as Recordsets?

Question: Can the latest version of ADO (ActiveX Data Objects) read and write an XML file as a recordset? Answer: Ah, let me qualify that: ADO 2.1 can currently produce

DevX - Software Development Resource

Modify XML Using DCOM From the Cache

Question: How can I modify and update XML docs that are stored in the cache using a DCOM model (client side)? Answer: Given that caching is an IIS (Internet Information

DevX - Software Development Resource

Truncating the Last Five Characters in a Field

Question: How do I truncate the last five characters in a field? (The string length varies from row to row.) Answer: Try something along these lines: select left(myfield, datalength(myfield)-5) Related

DevX - Software Development Resource

Forcing a Linefeed in SQL

Question: How do I force a linefeed character using SQL? I created a report (see below) but when I e-mailed this report from Unix the carriage return was not interpreted

DevX - Software Development Resource

Select Statement Not Working

Question: I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact

DevX - Software Development Resource

Using XML Within VBA

Question: Does XML work with VBA (Visual Basic for Applications)? I’m looking for a quick and easy way to store variable information that will be static once it has been

DevX - Software Development Resource

T-SQL Data Conversion

Question: I want to convert a signed integer into a 16-bit binary as part of a SELECT statement. For example: select myint, howeveritsdone as Binaryfrom mytablemyint Binary—- —————–137 1111111101110111-100 1111111110011100

DevX - Software Development Resource

Values Resulting to Null

Question: I want to add two numeric fields with values like these: Example 1: One field named Amount contains 565.25 and other field named Ticket contains null. select amount +

DevX - Software Development Resource

Creating a Crosstab

Question: How can I create a crosstab in SQL Server 7.0? I’m used to Microsoft Access, where I can use columnheading and rowheading. Does this work in SQL? Answer: This

DevX - Software Development Resource

Insert Trigger on Parent Table

Question: I have two tables and both tables have a one-to-many relationship. I want to add a new single record in the first “transheader” table (key is autonumber) and get

DevX - Software Development Resource

Extracting Dates

Question: How do I extract dates from SQL where the date type is a datetimestamp? I have the following SQL statement: select * from Patient where PatientDOB = “03/01/58” It

DevX - Software Development Resource

Unselect All Radio Buttons in Visual InterDev

When the Visual InterDev Scripting Object Model (SOM) creates an option group object (a set of radio buttons), it selects the first radio button when the page loads. You may

DevX - Software Development Resource

Discover the Time Difference in JavaScript and ASP

If you need to calculate a time difference between your Web server and visitors to your site, look into the JavaScript getTimezoneOffset() method. It returns the time zone difference in

DevX - Software Development Resource

Function Sequence Error

Question: I have WinNT4.0, Service Pack 5.0 SQL Server7.0, ODBC Driver for SQL 3.70.06.23. I have a servlet program that connects to a JDBC-ODBC bridge and accesses the database. If

DevX - Software Development Resource

Automatically Logging Users Off

Question: I am running SQL Server 7.0 with 20 user licenses. I have about 40 users, of which only 10 are logged on at once. The problem I am running

DevX - Software Development Resource

Importing Dates Earlier Than 1752

Question: When I try to import data to SQL, I find a problem in exporting the date values that occur earlier than the year 1752. Since I am working in