Search found 174 matches
- Saturday 23rd October 2021 8:26pm
- Forum: General
- Topic: Attach to sqlite file over my network
- Replies: 1
- Views: 1911
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...
- Tuesday 5th October 2021 8:20pm
- Forum: General
- Topic: advice needed re mysql decimal field type
- Replies: 3
- Views: 2572
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
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
- Thursday 26th August 2021 7:29am
- Forum: Component
- Topic: is there a tuturial for dynamic control creation
- Replies: 11
- Views: 9593
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: 3235
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: 2653
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: 3836
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: 3473
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: 3473
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: 2867
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: 1847
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 ...