Gambas ONE

In the treeview control, select ShowCheck in the parameter list. This enables a single select only radio button next to each treeview item. If you then set the mode parameter to multiple , the radiobutton changes to a checkbox and and you can select multiple items in any child node. The Selection pa...

Extract data to CSV file with table field names as headers. KeyTable is the name of the target table in the database AG.DateFormatFiles = "YYYYMMDD" The rest should be fairly obvious. Public Sub ExtractDataAsCSV() Dim OutFile As File Dim TmpLine As String Dim Delimiter As String = ",&...

I did this a while ago with a scrollview and child checkboxes as I missed the checked list box of vb.net. Wrote a class to do all the grunt work and it worked perfectly but in the end, I found that a multi select list box does the same thing for much less work. I can point it at a data table and a r...

I'm glad that you are making changes to the way I do things as it's the best way to learn. It was only ever meant to be an example to show all the aspects of data management without any dataview controls. One of the reasons I abstract the data Get/Add/Change/Delete to a class, is that I can call tha...

It was 38 degrees here today in Perth Australia.
Your snowman is truly appreciated. !

My bad. When I built the lenses maintenance form, I used the existing Maker Form as a template. I forgot to change the remaining functions over to Lenses. Because I build my forms in the same way, you can use ( more or less) any form as a template to build a new form. To build the Mounts Form, which...

Double clicking on a row in the grid view opens that row for maintenance. The tool panel is disabled at that point so you cannot inadvertently: Add a new record while halfway through changing and existing record. The way in which the form works is that the Pan_Maint with the IO controls is hidden. E...

I do this in a rather 'clunky' way and it takes extra effort but it works. The following example shows a toolbox routine to get the id field from any table by providing 'a' name. All my tables have an id field and the names are unique. The AE ( Application Error management) module has a collection t...

I had a look at the database schema and there were a few things that were not needed. A database view is normally a complex(?) series of select statements using multiple tables. Having a view that is a single select statement is a bit pointless. I took your original data and built a quick project to...

Gambas uses an object called a STRUCT Public Struct Employee EmployeeNo As String FirstName As String LastName As String DateOfHire As Date Salary As Float EmployeeNumber As Integer End Struct There are some overheads: please read this carefully on the Gambas Wiki on the STRUCT The difference betwee...