Gambas ONE

I am experimenting with tasks. The creation of virtual tables in the database for a full text search takes a bit of time. I would like to start the database operation as a new task to keep the program responsive for user interaction. But I got stuck and I have no idea why. The task in class MyTask_F...

A Personal Lens Register The program oranises all sorts of lenses, lens makers, mounts and it is aimed for photography aficionados. It comes with a set of 9 lenses and you are able to add whatever lenses you want or own. Organising means: you can add specific details of lenses and - if you own one ...

an export into a csv file is not the problem since the database comes with a build-in solution. The import (insert if the record does not exist; update if exists) is imho quite tricky. If someone is interested in the details: my use case is 1) the database is released with a default set of lens reco...

stevedee, thanks for your time and effort. A short follow up to describe the intention: the simple idea behind is to export new and changed data from tables into a csv file using sqlite3 DB syntax beginning from a specific date because a new version of my little project Lens Register has been releas...

One more question re the format. the original CSV file looks like this, text is always in double quotes: ID,ID_Lens,Purchase_date,Purchase_price,Purchase_serial_no,Purchase_from,Purchase_lens_colour,Purchase_lens_condition,Purchase__comment,DateCreated,DateChanged 14,100,2019-04-25,"700€",...

Thank you, works like a charm.

Looks good but doesn't work for fields like "DateChanged" or "LensVariants". Most of my DB fields have just one uppercase letter in the beginning but some have two. My fault, I should have used just one naming convention in the DB design. Too late to change it.

I have a question re CSV files so I need to reopen the old thread: When I read ( myCSVfile.Read() ) the CSV file the first line with headers are completely in lower case although the fist letter of the word is a uppercase letter. The DB refuses to update the data as the field names are case sensitiv...

I am just experimenting with the Full-Text Search engine (FTS) in sqlite3. FTS allows to search in all columns of all tables w/o a full table scan in the DB. The performance is breathtaking (with a lot of non-sense test data). This is quite usefull if one is looking for specific information in a rel...

I am happy to provide a first beta release of The Lens Register. If you are an photography aficionado the application enables you to manage lenses in general, your purchases, sales and clean-lube-adjust jobs. There are a lot of information about lenses available so I organised them into different ta...