Hello list,
Recently the question came up regarding how to round a numeric value in
a Base application.
A couple of answers come to mind.
First you can do this using a function in an SQL select statement.
The HSQLdb database engine supplied with Base includes the function
round( a, b ) and you can find it documented at:
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Numerical_Functions
Then of course there is OOoBasic.
Oddly the basic language does not directly supply a round function so
you can always create your own OR you can use the 'round' function
supplied with Calc from within a basic script.
For a good example of both approaches you can look to this post at
OOoForum.org:
http://www.oooforum.org/forum/viewtopic.phtml?t=75251
Happy coding,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
