Tip Bank

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

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

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

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

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

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

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