The Latest

DevX - Software Development Resource

Verify a Check Box Using JavaScript

It is possible to see if a check box has been checked or not in JavaScript. This may come in handy during form validation. A check box has a checked

DevX - Software Development Resource

Inserting Page Breaks in a Report

Question: How do I insert page breaks into a SELECT report? The report is sorted by a column that contains about five separate values, and I would like a new

DevX - Software Development Resource

Importing Data Containing a CR/LF

Question: How can I import data into a datawindow if the data blob contains CR/LF as part of its data? I am using dw.object.data and dw.importstring for distributed data transfer.

DevX - Software Development Resource

Adding the Identity Property to Existing Fields

Question: I have a users table with primary key USERID. The table is already created and loaded with pre-existing data. I now want the USERID field to be self-incrementing&#151that is,

DevX - Software Development Resource

Changing an Installed Code Page

Question: How do I change the code page in SQL Server 7.0 once it has been installed? Answer: The code page is selected with sort order upon install. Though you

DevX - Software Development Resource

Dropping Tables at Beginning of Statement

Question: I am trying to create a procedure that first drops the table “table” but only if it already exists. How do I create the statement using “if exists” or

DevX - Software Development Resource

Comparing Text File with Existing Table

Question: How can I go about reading in a (comma-delimited) text file and comparing it to an existing table? If there is a match on the key field, the row

DevX - Software Development Resource

Converting from FoxPro to Oracle

Question: Can you convert Visual FoxPro forms and reports to Oracle forms and reports? If you can, how is this done? Answer: I am not aware of anything that performs

DevX - Software Development Resource

Hiding the Main FoxPro Window

Question: Is it possible to completely hide the main Visual FoxPro window when I run an executable? In my main program, I use “_VFP.Visible = .F.”, but the main window

DevX - Software Development Resource

Using MS Word to Spell-Check in PowerBuilder

Question: I need to incorporate Microsoft Word 97 spell-check functionality into PowerBuilder. Which MS Word functions are required to do the task? Answer: To interface to the Word spelling checker

DevX - Software Development Resource

Using Menu to Scroll a Row in a DataWindow

Question: How can I use a Menu Object that associates with MDI to scroll a row in a DataWindow on an ActiveSheet? Answer: To achieve this you should map a

DevX - Software Development Resource

Employ Error Handling With ASP

Without error handling, any ASP (Active Server Pages) error is fatal as it will stop the execution of your page. To bullet proof your ASP, you can add error handlers.

DevX - Software Development Resource

DHTML Loads Faster Than Accompanying HTML

Question: I often have the problem in which the DHTML on my page loads faster than the accompanying HTML. Therefore, users are enticed to click away at elements, which trigger

DevX - Software Development Resource

Encountering Tabular Data Control Error

Question: I have an index page where the user clicks on a name to bring up that person’s biography on the next page. The names are hyperlinks to the next

DevX - Software Development Resource

How to Make a Patch for a Product Upgrade

Question: How would a person make a patch to upgrade their software in VB6? Answer: The best way to do this, with the least amount of work, is to use

DevX - Software Development Resource

ADODB.Recordset Type “Not Defined”

Question: I copied the following code from a good book on e-commerce, but the VB code (Visual Studio 6.0 Enterprise) gets an error on the Dim rsBankData line “User-defined type

DevX - Software Development Resource

Printing a Barcode (GIF) From Netscape 4.05+

Question: I have a barcode saved as a GIF that is truncated each time it is printed from Netscape. It prints fine in Internet Explorer and Netscape 4.04 but does

DevX - Software Development Resource

Visual C++ DLLs Need a DEF File for VB Clients

The VB community is still waiting for somekind of tool to create “real” DLL with Visual Basic.Awaiting for this to arrive with VB x.0 (x Writing DLLs with C/C++The message

DevX - Software Development Resource

NZ – Check whether a value is Null

‘ Check if a value is Null. If not it returns the value, ‘ otherwise it returns the ValIfNull argument, or zero/null string’ if the second argument is omitted” This

DevX - Software Development Resource

Reuse a Recordset’s Connection

ADO lets you create a Recordset without creating an explicit Connection object, using the following syntax: Dim rs As New ADODB.Recordsetrs.Open “Authors”, “DSN=Pubs” If you later want to create another

DevX - Software Development Resource

Export DAO databases to any ISAM format

Everyone tells you how to import, but even MS-VB techs start coughing when you ask how to export with DAO! In fact, their own documentation clearly states that it can

DevX - Software Development Resource

Draw a Simple Bar Chart in HTML

There are a lot of graphics packages for Web pages on the market, but sometimes you still want a homegrown solution. Using just HTML, it is possible to create simple