Search found 134 matches

by Quincunxian
Saturday 23rd October 2021 8:26pm
Forum: General
Topic: Attach to sqlite file over my network
Replies: 1
Views: 26

Re: Attach to sqlite file over my network

Hi CM, The official SQLite Over a Network Caveats and Considerations is here Even they suggest using a PostgreSql engine. I've tried this multiple times and like you, still have not been able to get a working version. MySQL is another option - You should be able to get it installed on your server an...
by Quincunxian
Tuesday 05th October 2021 8:20pm
Forum: General
Topic: advice needed re mysql decimal field type
Replies: 3
Views: 221

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: 954

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: 527

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: 290

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 07th August 2021 9:09pm
Forum: Project showcase
Topic: Bring Them On
Replies: 3
Views: 477

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: 577

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: 577

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: 432

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: 304

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 ...