You can convert a float to a currency by using Round(
Value = Round ( Number [ , Digits ] )
Rounds a number to its nearest integer, if Digits is not specified.
If Digits is specified, rounds to 10 ^ Digits.
Examples
PRINT Round(Pi, -2)
RunPlay
3.14
PRINT Round(1972, 2)
RunPlay
2000
Search found 173 matches
- Tuesday 5th October 2021 8:20pm
- Forum: General
- Topic: advice needed re mysql decimal field type
- Replies: 3
- Views: 2555
- Thursday 26th August 2021 7:29am
- Forum: Component
- Topic: is there a tuturial for dynamic control creation
- Replies: 11
- Views: 9524
Re: is there a tuturial for dynamic control creation
Have a look at the webview example in Gambas examples on the site.
From memory, it creates tabs automatically when you select the correct option.
Might give you a nudge in the right direction.
From memory, it creates tabs automatically when you select the correct option.
Might give you a nudge in the right direction.
- Wednesday 11th August 2021 10:32pm
- Forum: General
- Topic: Dynamic hierarchy
- Replies: 4
- Views: 3223
Re: Dynamic hierarchy
To re-order the controls you will need to have them in a container - A Panel is well suited to this. I use something similar to set tool buttons in a horizontal panel - This example is set for a vertical sequence. {As per your example} If you want to centre them in the panel, you can use Ctrl.X = (I...
- Tuesday 10th August 2021 11:24am
- Forum: Project showcase
- Topic: Very Basic Spell Checker
- Replies: 1
- Views: 2639
Very Basic Spell Checker
I've been trying to create a basic spell check for a larger gambas project I'm working on, and this is what I have so far. It's clunky but workable (for a given value of workable :roll: ) It uses the command line tool 'spell', which is part of ispell application from what I understand. The attached ...
- Saturday 7th August 2021 9:09pm
- Forum: Project showcase
- Topic: Bring Them On
- Replies: 3
- Views: 3813
Re: Bring Them On
You've come a long way since the old... Mid version Gambas 2... days.
Nice !
Nice !
- Saturday 31st July 2021 9:55pm
- Forum: General
- Topic: Exec & Shell
- Replies: 5
- Views: 3442
Re: Exec & Shell
Thanks guys. @ Bruce - The Gambas Quote function has failed on every SQL statement I've used it on so far, so my confidence is somewhat lacking. I'll have another look to cover all bases, but I'm not confident. @Cogier. I'm using LibreOffice but have always used the soffice application for command l...
- Saturday 31st July 2021 4:41am
- Forum: General
- Topic: Exec & Shell
- Replies: 5
- Views: 3442
Exec & Shell
Greetings all. I'm trying to run an Open office command line instruction using Exec or Shell. It's not working, but if I run exactly the same command from the terminal, it works as required. The process uses 'soffice' to convert a writer document (.odt) file to a txt file. Terminal command: soffice ...
- Tuesday 27th July 2021 9:46pm
- Forum: General
- Topic: SQL Advice
- Replies: 3
- Views: 2854
Re: SQL Advice
Hi Andy, Is there any reason why this needs to be a TinyInt? From what I can understand on the SqLite web site, an Integer and a TinyInt storage space on disk is a byte more. Unless you are transacting M's of records, then it should not make that much of a difference. If transaction time is critical...
- Monday 26th July 2021 1:50am
- Forum: General
- Topic: TextEditor Selected text font.
- Replies: 1
- Views: 1840
TextEditor Selected text font.
Is there a way to set the selected text to bold or italic ? As far as I can see, you can only set the font to the whole document. What I would like to do is select a single phrase in a sentence and set it to italic only. From what I understand, the Gambas code editor is made from this component but ...
- Friday 16th July 2021 10:15pm
- Forum: General
- Topic: Gambas Project Folders & Files
- Replies: 4
- Views: 2972
Re: Gambas Project Folders & Files
Yeah, it does make a difference.
I've spent some time looking for a error only to find out I'd capitalised something in a file/folder name.
That's one of the main reason I prefer setting up dotted references. - Do it once, do it right.
I've spent some time looking for a error only to find out I'd capitalised something in a file/folder name.
That's one of the main reason I prefer setting up dotted references. - Do it once, do it right.