For the Query Database Smart Service, it looks like it doesn't allow an aste

nickh413445

Certified Senior Developer

over 9 years ago

For the Query Database Smart Service, it looks like it doesn't allow an asterisk (*) anywhere within the SQL statement field. The problem I'm running into is that I need to do a multiplication function within the SQL.
How do would we do multiplication in that SQL Statement box without using the asterisk?

Discussion posts and replies are publicly visible

Parents

0 nickh413445
Certified Senior Developer
over 9 years ago

Yes, the SQL statement runs without any problem on the db client. I can't post the formula we're using, but here is a generic SQL statement that is giving me the same error:

SELECT any_column FROM generic_table where 180*tan(45)*cos(45)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nickh413445
Certified Senior Developer
over 9 years ago

Yes, the SQL statement runs without any problem on the db client. I can't post the formula we're using, but here is a generic SQL statement that is giving me the same error:

SELECT any_column FROM generic_table where 180*tan(45)*cos(45)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data