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

nickh413445

Certified Senior Developer

over 10 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 10 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 10 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