The Latest

DevX - Software Development Resource

Get SQL Before Execution

Question: Is there any way to capture SQL at the transaction object level? Answer: If you are using a datawindow/datastore object, then you can add code to the SQLPreview event

DevX - Software Development Resource

Alternative Sharing for Outlook Folders

Question: Can we publicly share Outlook folders in Outlook 97, without using Microsoft Exchange Server? Answer: The easiest solution for you would be to upgrade to Outlook 2000 and use

DevX - Software Development Resource

Exchange 2000 and Multiple Domains

Question: How do I get multiple domains in Exchange 2000? Answer: I’m not sure what you mean by multiple domains in Exchange. Exchange 2000 allows you to have only a

DevX - Software Development Resource

Insert and Amend Datestamps

Question: I have a table in Informix that is changed regularly. The records have no datestamp, so how do I get the date/time of amends and inserts to this table

DevX - Software Development Resource

SQLCODE Error -0000019514

Question: When I do aDECLARE CURSOR FOR SELECT, it returns a SQLCODE = 0. When I do an OPEN CURSOR, it also returns a SQLCODE = 0. But I have

DevX - Software Development Resource

Database Performance

Question: Our Sun E450 system seems slow, especially when 20 users log in together to our Baan ERP system. The physical RAM is 640MB and the disk space has about

DevX - Software Development Resource

Autoforwarding Public Appointments to a Group

Question: How do I forward appointments made to a public calendar to a set group of people? Answer: That’s fairly easy to do. First, open your folder list (View |

DevX - Software Development Resource

Win2K and Outlook2K Exchange Connect via PPTP

Question: When I try to access Exchange Outlook, it produces the following message: “The Microsoft Exchange Address Book was unable to log on to the Microsoft Exchange Server computer. Contact

DevX - Software Development Resource

Moving a User’s Folder

Question: We have a user on Exchange Server that no longer can access his account (“User does not have permission to log on to Microsoft Outlook”). I remember seeing an

DevX - Software Development Resource

Database Limits

Question: I read recently that Exchange databases, like the Public and Private Information Stores, are highly susceptible to corruption when exceeding 4GB. Our Exchange 5.5 (Standard Edition) claims a 16GB

DevX - Software Development Resource

Multiple Inserts Error

Question: What does the following Informix error message mean, and what can I do to prevent it: “could not position within a file via an index” It happens when I

DevX - Software Development Resource

Validation of Textbox

Question: How do I validate a textbox, which doesn’t have any control source, so if it’s empty it should not lose the focus until the user enters some value? Answer:

DevX - Software Development Resource

Disable Toolbar Control

Question: How do I make the toolbar not movable? Answer: To disable the toolbar control from the user, you need to alter a property on your application object. In the

DevX - Software Development Resource

Hiding Rows in a Result Set

Question: If I retrieve a record from my SQL into my DataWindow, can I hide the fields that return as 0? Answer: You can use the filter command to remove

DevX - Software Development Resource

Dynamic Global Variable Declaration

Question: Can I declare a global variable at runtime? Answer: Yes and no. You cannot add a global variable at runtime, but you can dynamically create an object and store

DevX - Software Development Resource

No Soctcp Option

Question: I’m installing IDS 7.3.x on Sol 2.6 with Connect 2.01, and when I attempt to initialize through onmonitor, I do not get an option for soctcp. I’ve even tried

DevX - Software Development Resource

Displaying Time in Different Time Zones

Question: I have seen an easy way to increase any given portion of NOW(), but it was months ago and I can’t find it again. What I want to accomplish

DevX - Software Development Resource

Calling the CD-Rom

Question: I would like to know how to call the CD-Rom, or rather search for its drive letter. Answer: You can use the FileSystemObject (Microsoft Scripting Runtime in the references

DevX - Software Development Resource

iHTML

Question: How can I retrieve the images that are stored in the SQL Server Database Table by using iHTML? Answer: I, as well as many others, generally discourage storing images

DevX - Software Development Resource

All-Encompassing Try

Question: I was told that in order to make my program easier to read, I shoulduse try to cover all of my program, then catch every exception at the endof

DevX - Software Development Resource

The binary_search Algorithm

STL’s binary_search() algorithm traverses a sequence and returns a Boolean value indicating whether the sought-after element exists in that sequence. binary_search() is declared in the header as follows: bool binary_search

DevX - Software Development Resource

Useful STL Terminology

Here are some key terms that you may find useful for reading Standard Template Library (STL) literature and documentation. ContainerA container is an object that stores objects as its elements.

DevX - Software Development Resource

Declarations With Implicit int Aren’t Permitted

Does your compiler accept the following declarations? volatile x; const y = 0; In pre-standard C++, the default type in such incomplete declarations was int. Thus, the first declaration would

DevX - Software Development Resource

Blocking Object Copying and Assignment

To block copying and assignment of an object, explicitly declare the assignment operator and copy constructor private. Don’t define them, (there’s no point in defining them because they can’t be

DevX - Software Development Resource

Accessing SQL and Visual Basic

Question: I am developing a database program using Access and Visual Basic. I want to display data in a form where the data comes from two tables. For example, the

DevX - Software Development Resource

Ordering Query Output By Two Fields

Question: I want to order the output of my query by two fields. Is this possible? That is, if two values are the same, I want the output ordered by

DevX - Software Development Resource

Datatype Decision

Question: I have a field that stores lots of data (up to 8,000 characters). I thought that I could maybe save disk space if I stored this data as varbinary

DevX - Software Development Resource

Autonumbering in SQL

Question: I am having to reformat data for addition to a database. My current struggle involves an identification field for certain records. In the new database it needs to be