Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Pascal Delphi Databases > Paradox + compo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 966 of 986
Post > Topic >>

Paradox + composite key

by "sirtap" <cut@[EMAIL PROTECTED] > Jul 11, 2007 at 04:05 PM

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
 




 1 Posts in Topic:
Paradox + composite key
"sirtap" <cu  2007-07-11 16:05:25 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Jul 25 0:07:33 CDT 2008.