Hi

I have a problem with a composite key in the Paradox database. I want to
select rows using a list of key pairs I have. I want to use IN clause. In
most relational databases it would be something like that:

SELECT * FROM Table1 WHERE (A,B) NOT IN ((1,1),(2,10))

A and B are composite key.

But in Paradox (standard version on Windows XP) it doesn't work.

Regards

Andrew

Here's an (untested) idea with psuedo-SQL. If fields A and B are
already CHAR, then there would be no need to CAST. Make sure you get
the exact CAST syntax correct by reading the Paradox LocalSQL help as I
am just guessing here.


SELECT * FROM Table1 WHERE CAST(A AS CHAR) || CAST(B AS CHAR) NOT IN
('ConcatenatedValueOne', 'ConcatenatedValueTwo')

"Ed Nash" <ask.me (AT) specifically (DOT) pls> wrote

Quite interesting, but I've already done it like that:

WHERE NOT (
(A = 1 AND B = 1 ) OR
(A = 2 AND B = 3 ));

Regards
Andrew