Tip Bank

DevX - Software Development Resource

Editing Win95 Registry

Question: Is there any way of editing the Win95 Registry other than exporting it to a text file?. If not, how can I quickly change the registry ie. When exported

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

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

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

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