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 Robert Shankin
Appian Employee
over 9 years ago

Nick -
I'm assuming this is a SQL statement you've tested working in your db client. Is that correct?
If so, would you share your SQL as if you were writing it directly in the db client?
That might help us come up with some ideas that would work for you.
Thanks,
Rob
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Robert Shankin
Appian Employee
over 9 years ago

Nick -
I'm assuming this is a SQL statement you've tested working in your db client. Is that correct?
If so, would you share your SQL as if you were writing it directly in the db client?
That might help us come up with some ideas that would work for you.
Thanks,
Rob
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data