Topic: SQLQuery and grid formatting
Good Afternoon Dmitry,
A bit of help please.
I have 2 currency fields, both defined to 2 decimal places and with a ',' as a thousands separator.
In my tablegrid when all rows are retrieved, this is displayed correctly, for example 1,234.00 (dmitry 1.jpg).
After doing an SQLQuery search, the formatting is lost and displays as 1234 (dmitry 2.jpg).
Can the correct format be specified as part of the SQLQuery?
If not, what is the syntax for specifying it in the script?
Thanks,
Derek.