Tip Bank

DevX - Software Development Resource

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

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

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

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

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

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