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

DevX - Software Development Resource

Toolbar image list

Question: I am trying to setup a toolbar using the MS windows common controls. How do you initialize the image list? The toolbar works but I cant get a image

DevX - Software Development Resource

Why Do I Need OS/2?

Question: I have just started working with an application developed in VB that my co-workers say can only be run in the Windows environment through OS/2. Supposedly the program uses

DevX - Software Development Resource

Updating Many Columns

Question: I’m looking for a syntax that can be used to update several columns in an SQLtable. Although I’ve found a number of topics related to ‘update’, they allseem to

DevX - Software Development Resource

What is normalization?

Question: Will you please help me in locating a definition of the term “normalizeddatabase”? Answer: Normalization of relational databases is the process of ensuring that thedatabase does not contain redundant

DevX - Software Development Resource

Length of Table and Column Descriptors

Question: What is the length of a table name or a column name?I know that for some engines it is 18 characters.Is this a SQL limitation or engine limitation ?

DevX - Software Development Resource

WHERE (multiple values)

Question: I have a form in which the user can select multiple values of “Manufacturer” from a drop-down list. The query should then select from the database all records in

DevX - Software Development Resource

Can I filter DDDW values out of itself?

Question: I have a tabular DataWindow with a DDDW. Can I filter the dddw to include only valuesthat have NOT already been selected ? Answer: There is a short, a

DevX - Software Development Resource

QueryWhere()

Question: Can I use more than one criteria in the QueryWhere(“col1=’val1′”&”col2=’val2′) to refresha bound grid? I would really appreciate an answer or a solution; we are on the border line

DevX - Software Development Resource

Definition/Summary of ISQL

Question: I would appreciate an introductory definition/summary of ISQL (Interactive SQL?). Answer: As you’ve guessed, ISQL is an acronym for Interactive SQL. In general,ISQL describes any tool or interface that

DevX - Software Development Resource

Creating Auto-Incrementing Columns

Question: How can I make a column that will automatically increment by one each timea new row is inserted into the table? Answer: The solution will depend upon the database

DevX - Software Development Resource

Converting Legacy Data

Question: What are the advantages of converting a PC-based Cobol application to a P- based relational database? Answer: The most compelling advantage of converting legacy data into a relationaldatabase management

DevX - Software Development Resource

How to determine current filter/sort associated with DataWindow

Question: How can I determine the current filter and/or sortassociated with a DataWindow?For example:s_old_filter = dw_1.WhatsTheCurrentFilter()dw_1.SetFilter(“”)dw_1.Filter()// Do somethingdw_1.SetFilter(s_old_filter)dw_1.Filter() Answer: You can use the Describe function:ls_OldFilter = dw_1.Describe( “datawindow.table.filter” )

DevX - Software Development Resource

Phonetic Searches

Question: How can I perform a phonetic search in SQL? I need to search a database ofnames, but exact matches won’t work. Using phonetic matching, I could finda name registered

DevX - Software Development Resource

Dynamic UserObject in Tab Control

Question: I’m looking for a way to put a dynamic UserObject in a Tab Control. The PowerBuilder documentation mentions a technique to put it in a window, but nothing for

DevX - Software Development Resource

Adding a Column at a Specific Position

Question: How can I add a column to a table (not just at the end of the table)? For example: create table test(first_col char(20),second_col char(20)); I want to alter table

DevX - Software Development Resource

OPO Example Archive??

Question: Does an archive or site exist thathas examples or templates for Power Objects? I’ma neophyte, and would like to start with somealready developed applications that I can modify.Specifically, I’m

DevX - Software Development Resource

List of files in a directory

Question: I need a way of letting the user pick a file name or names from a list. I would prefer this not to be in a dialog box. In

DevX - Software Development Resource

Record Count by Quarter

Question: I have a table set up with training records by date. I want to produce a query that will count how many training sessions took place for each quarter

DevX - Software Development Resource

Stripping concatenated fields

Question: I have a table that contains a concatenated field delimited by colons. The field contains approximately six values I want to house as separate columns on the table. How

DevX - Software Development Resource

Is there a driver for Oracle 7.3.2.3?

Question: Is there a driver for Oracle 7.3.2.3 — the version Oracle recommends for NT 4.0? Answer: Yes, but it is not readily available (as of this writing, 4/14/97). You

DevX - Software Development Resource

Datawindow Printing

Question: How can I print two DataWindows on to one page? Do you have to use a composite DataWindow? Or is there a way to do it with two separate

DevX - Software Development Resource

Connecting forms through a button

Question: I have number of forms, including a MainMenu form. On the MainMenu form I have several buttons that I want to click and connect to my other forms. I

DevX - Software Development Resource

Two Ways of Indexing a Paradox Table

Question: Two ways of Indexing a paradox table Answer: Having done a lot of work with Paradox in the past, there are things I’ve learned in Paradox that I’ve needed

DevX - Software Development Resource

A Simple Property Editor

Question: A simple property editor Answer: This is an introductory level article about creating a simple property editor that I hope will get you started. I’ll provide enough information about

DevX - Software Development Resource

Using SQL2 Built-in Functions

Question: Using SQL2 built-in functions Answer: A problem that’s rampant with many software tools today, even one as complete and comprehensive as Delphi, is that documentation on many important subjects