Home » SQL & PL/SQL » SQL & PL/SQL » Missing Parenthesis error
Missing Parenthesis error [message #201567] Sun, 05 November 2006 20:56 Go to next message
kenbubblez
Messages: 1
Registered: November 2006
Junior Member
Hi i got missing parenthesis error when trying to execute this

select....
iif(dlrates.mdin like 'M', Sum(cloan.cpam * dlrates.sprt), Sum(cloan.cpam / dlrates.sprt)) AS USD,.....

please help
Re: Missing Parenthesis error [message #201573 is a reply to message #201567] Sun, 05 November 2006 22:16 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you plz post complete query.
iif(dlrates
here should be "if" not "iif".
Re: Missing Parenthesis error [message #201588 is a reply to message #201567] Sun, 05 November 2006 23:53 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

if i am not wrong ,it's an MS Access syntax.
Quote:
iif(dlrates.mdin like 'M', Sum(cloan.cpam * dlrates.sprt), Sum(cloan.cpam / dlrates.sprt)) AS USD,.....


use CASE statement instead.

something like.
 ...case when dlrates.mdin like 'M%' then
sum(cloan.cpam*dlrates.sprt)
else sum(cloan.cpam / dlrates.sprt)
end USD from your_table_name....



regards,
Previous Topic: How to find (full) Cost of a query?
Next Topic: Space Printing problem...
Goto Forum:
  


Current Time: Sat Dec 10 20:18:02 CST 2016

Total time taken to generate the page: 0.10442 seconds