The Latest

DevX - Software Development Resource

SQLLog Wizard

The SQLLog Wizard is used to specify which tables are to be audited. The output of the wizard is a SQL script that that can be run in the Query

DevX - Software Development Resource

Oracle OLE DB and MTS

Trying to figure out how to use the Oracle OLE DB Provider under MTS or COM+ and with Oracle’s OS Authentication? This article explains how these parts fit together and

DevX - Software Development Resource

Image Changeovers

Question: I have seen plenty of text on script dealing with mouseovers, or ‘animation’ where an image can change every few seconds, but is there a way I can write

DevX - Software Development Resource

Form Validation

Question: I need to perform a validation on five fields in a form. The logic is: If field1 length >0 then disallow form submission if field2,field3, field4, and field5 are

DevX - Software Development Resource

Pop-up Window with Links to New Pages

Question: I want to set up a series of links in a pop-up window which, when clicked, will (a) close the popup window and (b) redirect the main page to

DevX - Software Development Resource

Checking the State of a Stream

The iostream family of classes provides the following member functions and operators for checking the stream’s state: bool good() // returns true if no error flag is setbool eof() //

DevX - Software Development Resource

Comma Separated Expressions

An expression may consist of one or more subexpressions. You can group several expressions in one statement and separate them with commas. For example: if(++x, –y, cin.good()) // three expressions

DevX - Software Development Resource

The Semantics of const_iterator

A recent subscriber of one of the C++ newsgroups posted the following question:Why did the C++ standardization committee created a const_iterator instead of a const iterator? Or, at least, why

DevX - Software Development Resource

Treating a Vector As an Array

In certain contexts, you have to treat a vector as an array of its elements. For example, suppose you have a function that takes int * as its argument. How

DevX - Software Development Resource

The erase() Member Function of Associative Containers

The associative containers std::map, std::multimap, std::set, and std::multiset have the following three overloaded forms of the member function erase(): class map // simplified for brevity{public://..other members void erase(iterator position); //

DevX - Software Development Resource

Object Class

Question: Every class in Java is supposed to extend the Object class by default. In case a user class extends some other class (e.g., if myclassextends yourclass), then is it

DevX - Software Development Resource

Constructors and Member Variables

Question: After I have already declared an object, how can I call its constructor again to re-initialize its member variables? Answer: You can’t do that. C++ guarantees that for each

DevX - Software Development Resource

Static Methods

Question: What is the purpose of static methods in Java? Answer: Static methods can be invoked without an instance of an object. They provide the ability to execute methods in

DevX - Software Development Resource

Choosing a Column Depending on Procedure Argument

Question: Can I specify the column I want to select from as an argument to the procedure? Something like: create procedure show_product(language char(2), ID integer) returning char(255);define p_prod_name CHAR (255);select

DevX - Software Development Resource

Memory Initialization Problems

Question: I cannot initialize the program after I have installed it. When I run “oninit”, it seems to work, but then when I run “onstat” it tells me that the

DevX - Software Development Resource

Forms in Informix OnLine 7.2

Question: In Informix SE, I can use ISQL to generate a default form from a table and then query, update, or delete data within the form? How do I do

DevX - Software Development Resource

Selective Exchange Restore

Question: Is there a way to perform a selective restore? I need to restore just one mailbox or public folder. I’m using the NT backup/restore utility. Answer: I’m afraid not.

DevX - Software Development Resource

Ensuring Database Security

Question: What are some of the ways that databases can be secured so that they can’t be hacked into, etc.? Answer: The first level of security is always the OS

DevX - Software Development Resource

Determining Database Size

Question: I am using Informix 7.24 and my raw partitions are getting quite large. Is there a way to tell the size of a database? I could then decide which

DevX - Software Development Resource

Ontape for Backups to Disk

Question: How can ‘Ontape’ functions be used to back up Informix/Lawson DB to disk? Is dbspace required or can a large area in a directory (e.g., /gsc/bigspace) be used? Answer:

DevX - Software Development Resource

LOCATE versus GO TOP

Question: Which is faster, LOCATE (without parameters) or GO TOP? How fast is the one from the other? Why is one faster than the other? Answer: They are usually equal

DevX - Software Development Resource

The Find and Change Properties Add-in

This Add-in lets developers quickly find & replace properties in their active VB6 project without exiting the VBIDE or editing any source code and with minimal usage of the vb

DevX - Software Development Resource

COM(+) Security: Follow-up

Introduction In my previous article [1], published atVB2TheMax site, I’ve described briefly how COM+ security and role-based securitywork. I promised you to discuss in the next article about web/IIS security;still

DevX - Software Development Resource

CamelCase – Convert a string to camel case

‘ convert a string to camel case’ for example: CamelCase(“new file name”) => “NewFileName”‘Function CamelCase(ByVal Text As String) As String Dim i As Long ‘ convert all non-alphanumeric chars to

DevX - Software Development Resource

FormatPhoneNumber – Format a phone number

‘ Modify a phone-number to the format “XXX-XXXX” or “(XXX) XXX-XXXX”.Function FormatPhoneNumber(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then

DevX - Software Development Resource

ConvertCamelCase – Convert from a string in camel case

‘ change a sentence in CamelCase to a sentence with spaces’ for example ConvertCamelCase(“FileExchange”) => “File Exchange”Public Function ConvertCamelCase(ByVal Value As String) As String Dim i As Long For i

DevX - Software Development Resource

FormatCreditCard – Format a credit card number

‘ Format a credit card numberFunction FormatCreditCard(ByVal text As String) As String Dim i As Long ‘ ignore empty strings If Len(text) = 0 Then Exit Function ‘ get rid