
December 24th, 2012, 10:10 AM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 1
Time spent in forums: 13 m 42 sec
Reputation Power: 0
|
|
|
Problem with the ROUND() function
Greetings All,
I am setting up the following variable in a line of code which is then used to access a database:
put "SELECT round(amount,2) FROM prlabordist" into dbCommand
When I run my code, I get the following error message: Expected lexical element not found: FROM
If I use: put "SELECT amount FROM prlabordist" into dbCommand, then I get a list showing the "amount" column from my database.
Am I missing something obvious here?
Thanks for your help.
John
|