Search found 174 matches
- Tuesday 24th May 2022 2:04am
- Forum: General
- Topic: Copy lines from TextArea
- Replies: 2
- Views: 1408
Re: Copy lines from TextArea
The insert command will work when the cursor position is a positive integer or zero (no current text) TextArea.Pos will set or return the current cursor position. TextArea.Text = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" TextArea.Pos = 0 TextArea.Insert("bbbbb") TextArea.Select(0, 3) Tex...
- Monday 11th April 2022 11:30pm
- Forum: General
- Topic: Newbie query - reading a data file
- Replies: 4
- Views: 3792
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: 3724
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: 17905
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: 2049
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: 4597
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: 4597
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: 422293
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: 8616
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: 8616
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 ...