devxlogo

The Latest

Calling a Function at Program’s Startup

Certain applications need to invoke startup functions that run before the application starts. For example, polling, billing, and logger functions must be invoked before the actual program begins. The easiest

Getting the Code Value of a Character

A character enclosed in a pair of single quotes is a constant expression that is evaluated to the numeric code of that character in the character set that the implementation

Calling a Help System

Question: Once I create a .chm help file with HTML Help Workshop, how do I call this help file from my .exe application? Answer: There is a simple answer and

Slow Report Generation

Question: I’m developing a VB client application (using VB5) with an Informix database in the backend. However, the report generation that Crystal Report incorporates has always been very slow. What

Text Datatype

Question: How do I search a text datatype column in an Informix database? Answer: Try using one of the text search datablades, if you are running an engine that supports

Informix and ASP Error

Question: When I try to connect to an Informix database (via ASP) located on another machine on our LAN, I get the following error: Microsoft OLE DB Provider for ODBC

Database Connectivity

Question: I am trying to connect to an Informix database via ODBC from Microsoft Access 2000. When I import a table from the Informix database, I see all the data.

Simple Component Testing

When creating ActiveX components, an easy way to test them is to add a module to the project (see the code below). In this module you can write methods that

Implement Catch All Blocks for Robustness

You can use Throwable class in catch block to catchall kinds of exceptions. This class is the base classof all errors and exceptions in the Java language. You can use

Overhead of Using Inner Classes

An interesting situation with method call overhead arises when you use inner classes. The inner class specification says that a private method of a class A can be used by

Multiple Entries That Meet Criteria

Question: How can I pull just the first match to a query? We have a database of jobs in process: jobno 12345op# 10 shear %complete 100op# 20 punch % complete

ADO with Stored Procedures

Question: How do I get both output parameters and output recordsets from the SQL7 stored procedures I call from ASP via the ADO command object? Answer: It is possible to

Client Caching of Java Server Pages

Question: When I redirect a request from a Servlet to a JSP, the browsercaches the JSP and won’t display an updated page without reloading.How do I prevent the page from

Sqlhosts

Question: Why when I try to run sqlexecd to set up ODBC do I get an error: -25553 unable to load locale categories. Answer: Check your environmental variables. If you

Get Date by Totaling All Seconds

Question: How do I get the total number of seconds between two dates? Answer: You can use the DATEDIFF function to calculate the difference between two dates. The value can

Database Property

Question: How do I programmatically change the database property of Forms so that I can put my data files anywhere? Answer: You can set the database properties of cursors in

Threading and SimpleDateFormat

Question: Is SimpleDateFormat threadsafe? I am trying totrack down a bug where a date formatted “yyyy-MM-dd” actually came outas 2000-06-0001. I have four threads accessing the format method ofmy date

NT Admin

Question: Can I move 600+ users from a standalone server to a PDC with all rights and information intact, without having to recreate the users on the PDC? Answer: Well,

Using the VFP Grid Without Bound Data

Question: Is there anything similar to the “Microsoft grid control” in Visual Basic that just displays a grid and does not bind data from a table? Answer: You could use

Visual FoxPro 6

Question: With an application compiled into an EXE, why when I select 1 topic, enter into it, and exit do I get booted out of FoxPro to the main Windows

Array Enumeration

Question: Is it possible to return an Enumeration of an array? Answer: There is no standard class for creating an Enumeration of an array.More often than not, when you use

Designing Tiers and Placing Business Rules in Them

Sometimes in a multi-tier system, designers tend to follow rigid object-oriented design rules to perform heavy data-centric manipulations in the middle tier. Remember, a thin line separates the operations that

Display an animated GIF using the WebBrowser control

The standard PictureBox control doesn’t support the Animated GIF graphic format. However, you can display these images by using a WebBrowser control: WebBrowser1.Navigate “c:ImagesAnimated.Gif” The only problem of this technique

Using XSLT to Comma Delimit Node Values

Question: I have the following code in an XML file: Fredonia AFB Russia Luka Russia 140N4506 64E3507 Sevastopl Bosie 140N4506 64E3507 Ukraine How can I set up an XSL sheet

Changing Link Color with Mouseovers

Question: How can I change the color of a link when the mouse is over the link? And how can I remove the line that underlines the links? I am

Creating Frames

Question: I want to make a simple frame for my Web site, but I don’t know how. I’ve looked through your tutorial but I still don’t fully understand. Can you

The Error Handler Add-in

This addin greatly simplifies adding error handling to VB programs. Simply register the DLL using REGSVR32 and the addin will be added into the Visual Basic tools menu. Keep the

The Tao of Recursion: Named Templates in XSLT

ascally RecursionExtensible Stylesheet Language Transformations, or XSLT, allows you to transform XML documents into other XML documents using XSL. Using XSLT can be very trying, but it is, in fact,

Bringing the Web to Your In-Box

ave you visited sites that allow you to “E-mail this page to your friend”? Have you tried it and sent the page to yourself to see what it looks like?