Gambas ONE

Double clicking on a row in the grid view opens that row for maintenance. Oh yes, thanks. My fault. I was curious and moved the panel into the background to see what's behind. So, I reverted it back and the behaviour of the form is exactly as described it. But ... I get an error when I double click...

Any questions, let me know. I still have a closer look into code, was cranking up the debugger and set a lot of breaking points. At some point I was wondering what happens when I double click a row in the Frm_Lenses. The panel "Pan_Tools" disables, the form seems to hang but still respons...

Just one word re the database view. The view in the my DB was just an example to find out if gb.db supports views in general. The answer is afaik no, unfortunately. The original DB scheme is very basic and there is probably no reason to use a database rather than a CSV file.

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

The link to the user mailinglist is very helpful. Thanks for that. I found the answer of my question " Is the db.gb control able to manage DB-views? ". The answer from Benoît Minisini in 2019 was "no" and I think it is still valid in 2021. https://lists.gambas-basic.org/pipermail...

hmm. Is there already a file in your docs directory named Lenses.sqlite? If so it nees to deleted or renamed.
I just recreated the DB with in a separate directory without any errors. It seems the SQL dump is OK to create a fresh new DB.

Steve, thanks for taking the time. Indeed there are two connections to the DB: first one is the "Connection1". The path needs adjustment (see attachment) according to your location of the DB Lenses.sqlite. Second connection is in Global.class. This is just another open connection by code t...

Cheers Bruce. I attached the sqlite3 database including some sample records and the project " Lens-Register ". If someone is interested to install it- here you go: 1. Fist of all install the database into a directory of your choice. The DB-file name must be " Lenses.sqlite " 2. I...

One more question. The subject points hopefully into the direction: In sqllite3 I created three tables and saved a view in the database. How can I bind the view to a db-control (DataSource, DataComboView or DataBrowser)? All these controls have a property "Table" and/or "Field", ...

Bruce, thanks for your help. I need to think about the problem with the DataComboView -controls. In the meantime I finished a rough solution re the use-cases I mentioned above in one of my posts. In detail: a form based DB-search in sqllite3 works for the dabase bound controls DataControl . When I s...