Search found 173 matches
- Monday 11th April 2022 11:30pm
- Forum: General
- Topic: Newbie query - reading a data file
- Replies: 4
- Views: 3731
Re: Newbie query - reading a data file
Is this more like reading binary data? If you know the field types of each record then it should be possible to READ the file under Gambas. You may need to do some trial and error to get the field types right but should not be too hard. See: Binary Data Representation (very) rough example of reading...
- Friday 1st April 2022 11:01pm
- Forum: General
- Topic: Splitter settings
- Replies: 5
- Views: 3474
Re: Splitter settings
The Layout parameter is used as a percentage so: Splitter1.Layout[20,80] will give the two child controls the available space based on a percentage calculation. The Splitter1.Settings[0] will equal the actual size of the first child control width being used. Note# I'm using the old HSplit control ( ...
- Sunday 16th January 2022 2:41am
- Forum: General
- Topic: Working with CSV files
- Replies: 19
- Views: 17546
Re: Working with CSV files
Extract any database table to CSV with fields as headers - Works well with SQLite but have not tried with MySql but should be generic enough to work. Must have a connection to your database open ($Con in the example below) Public Sub ExtractTableToCSV(InSavePath As String, InTable As String, AutoOpe...
- Sunday 2nd January 2022 3:50am
- Forum: General
- Topic: Comparing data from a table in different Databases
- Replies: 3
- Views: 2015
Re: Comparing data from a table in different Databases
There is an database ATTACH function in SQLite but it does not seem to be implemented in Gambas. If the changes are made on your server DB then you would have a Date changed or a Boolean flag to say that a value is changed and a unique identifier that is consistent between the server and local table...
- Saturday 11th December 2021 12:07am
- Forum: General
- Topic: Procedure Folding
- Replies: 9
- Views: 4510
Re: Procedure Folding
Yeah I thought that too, but when I checked, the cursor was on a different line. There may be some 'offset' involved though. I placed the cursor at line 130 at column 2, then did a full save. This is the line in the file : File[4]=".src/Cls_ToolBox_Forms.class:37.209" Moved the tab in GUI ...
- Friday 10th December 2021 8:52pm
- Forum: General
- Topic: Procedure Folding
- Replies: 9
- Views: 4510
Re: Procedure Folding
The same thing happens to me intermittently. I've been searching for a common factor for several months but can't find anything. Sometimes restarting the Gambas instance helps, sometimes a full reboot helps. Have been working on the same project over a long period of time, and when it happens, the C...
- Tuesday 7th December 2021 11:00pm
- Forum: General
- Topic: Did you know?
- Replies: 91
- Views: 412360
Did you know? - How to get a Random Word.
You can use this function to get a random word from your preferred dictionary. If you check the /usr/share/dict/ area, you can find other dictionaries you can use. Please check the actual lines(word count) in the dictionary and adjust the WordCount variable accordingly. UsedWords[ ] is a string arra...
- Thursday 4th November 2021 7:58pm
- Forum: Component
- Topic: FileChooser Message on Double click
- Replies: 4
- Views: 7617
Re: FileChooser Message on Double click
That fixed it. Changing the FileChooser property ReadOnly to True stopped the pop-up message. This has annoyed me for such a long time - thanks guys ! I use the Activate event to process a file selection on double click. Edit: The reason that the Activate event is used, 'may' be that when you have a...
- Wednesday 3rd November 2021 11:40pm
- Forum: Component
- Topic: FileChooser Message on Double click
- Replies: 4
- Views: 7617
FileChooser Message on Double click
When I double click a file in the file chooser I get the following message. Screenshot from 2021-11-04 10-33-57.png Is there anyway to disable it ? This appears before the 'Activate' process instigates. When you click on 'Overwrite' the process then continues as normal. Any suggestions ? Note# this ...
- Saturday 23rd October 2021 8:26pm
- Forum: General
- Topic: Attach to sqlite file over my network
- Replies: 1
- Views: 1782
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...