I’m creating a PDF Report in SC Enterprise with the latest updates.
If I set a desired precision on a field, I get an error from MySQL:
Error while accessing the database:
Unknown column ‘ROUND(MyField,2)’ in ‘field list’…[/INDENT]
A similar SELECT works fine from the MySQL command line.
What’s with the quotes (’) enclosing the call to ROUND()? That might cause this.
I noticed that trying to code this in the SQL causes a similar error:
ROUND(Price, 2) AS Price,
I get a similar error from that, even though it is valid SQL.
Probably separate but related:
If I try to change/remove/delete a precision on the field property (once defined), SC still calls ROUND() with the precision value that was first chosen (it cannot be changed or removed).