devxlogo

Tip Bank

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

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

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

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

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