Gambas ONE

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

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

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

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

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

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

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

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

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

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