Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cannot understand this error

 
Vaibhav Pingle
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi frnds.....

On running the following query......




i am getting the following error......

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression 'B.BNUMBER=T.BUY_BILL) AS BUY_DATE, BUY_PRICE, BUY_VENDOR, SELL_BILL,(SELECT B.BDATE FROM BILLS AS B WHERE B.BNUMBER=T.SELL_BILL) AS SELL_DATE, SELL_PRICE, SELL_VENDOR FROM TRADES T'.



but the same query runs fine in MS access....when run independently of java....

I am using MS Access as the Databse
[ November 27, 2006: Message edited by: Bear Bibeault ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic