Tip Bank

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

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

DevX - Software Development Resource

Circular referencing

Question: Circular referencing Answer: This tip addresses circular referencing between units; that is, where two units are dependent upon each other in some way. Or in more simple terms: two