[Gambas-user] Can't exec an sql string

[Fabricio Silva]

Hello guys,

I have this sql:  "select price from product order by cast (price as char)"
When I execute this sql inside phpMyAdmin it comes with the right result.
But when executing the sql inside Gambas 1.9.34 it comes with the error:
"Query failde: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near('price, ....."
I'm using price as varchar because in Brazil we use 147,00 instead of
147.00and I haven't figure out yet a way of showing the result with
","  whether
than dot when I use decimal or float types.

Regards
Fabricio Silva