Search found 173 matches

by Quincunxian
Tuesday 5th October 2021 8:20pm
Forum: General
Topic: advice needed re mysql decimal field type
Replies: 3
Views: 2462

Re: advice needed re mysql decimal field type

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
by Quincunxian
Thursday 26th August 2021 7:29am
Forum: Component
Topic: is there a tuturial for dynamic control creation
Replies: 11
Views: 9037

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.
by Quincunxian
Wednesday 11th August 2021 10:32pm
Forum: General
Topic: Dynamic hierarchy
Replies: 4
Views: 3074

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...
by Quincunxian
Tuesday 10th August 2021 11:24am
Forum: Project showcase
Topic: Very Basic Spell Checker
Replies: 1
Views: 2415

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 ...
by Quincunxian
Saturday 7th August 2021 9:09pm
Forum: Project showcase
Topic: Bring Them On
Replies: 3
Views: 3556

Re: Bring Them On

You've come a long way since the old... Mid version Gambas 2... days.
Nice !
by Quincunxian
Saturday 31st July 2021 9:55pm
Forum: General
Topic: Exec & Shell
Replies: 5
Views: 3232

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...
by Quincunxian
Saturday 31st July 2021 4:41am
Forum: General
Topic: Exec & Shell
Replies: 5
Views: 3232

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 ...
by Quincunxian
Tuesday 27th July 2021 9:46pm
Forum: General
Topic: SQL Advice
Replies: 3
Views: 2619

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...
by Quincunxian
Monday 26th July 2021 1:50am
Forum: General
Topic: TextEditor Selected text font.
Replies: 1
Views: 1657

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 ...
by Quincunxian
Friday 16th July 2021 10:15pm
Forum: General
Topic: Gambas Project Folders & Files
Replies: 4
Views: 2883

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.