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

Cascading Menu

Question: I am a new commer to VB and have been wondering if it is possible to have cascading pull down menus like the ones I see on the Win95’s

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

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

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

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

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 ?

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

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

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

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

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

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

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” )

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

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

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

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

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

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

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

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

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

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

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

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

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