devxlogo

We are an award-winning tech entrepreneurship website where trusted experts can provide value globally.

Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.

devxlogo

Trusted for 26 years

Over 30K Articles

1M+ Readers

Expert-reviewed

10K+ Tech Terms

As seen in:

microsoft logo
business_insider_logo
wired_logo
berkley
arstechnica_logo
hackernoon

The Latest

Restore Errant Focus to RichTextBox

If a RichTextBox control has the focus in a Multiple Document Interface (MDI) child form, it doesn’t properly regain the focus after your application loses and regains focus. To fix

Change Database Connection in SQL Server

In general, every user tends to work on a separate database on the server during the development phase of an application. It can be annoying for users to repeatedly change

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

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

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.

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,

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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