By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

error: missing right parenthesis

P: 27
This select statement works and gives me True/False in RC33 column however the second statement gives me following error. Any idea?

odbc--call failed.
[oracle][odbc][ora]ora-00907: missing right parenthesis

- - - this on works - - -
Expand|Select|Wrap|Line Numbers
  1. SELECT tblAccount.Acct_Num, tblAccount.STATUS, tblAccount.RC1, tblAccount.RC_2, tblAccount.RC_3, 33 In ([RC1],[RC_2],[RC_3]) RC33
  2. FROM tblAccount;

- - - this one gives me odbc error - - -
Expand|Select|Wrap|Line Numbers
  1. SELECT tblAccount.Acct_Num, tblAccount.STATUS, tblAccount.RC1, tblAccount.RC_2, tblAccount.RC_3, 33 In ([RC1],[RC_2],[RC_3]) RC33
  2. FROM tblAccount
  3. WHERE (33 In ([RC1],[RC_2],[RC_3])=-1);
Jan 10 '08 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,355
Please use code tags.

The =-1 should be outside the parentheses.
Jan 10 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.