How to edit a field in Base in a selection of datasets in one go?

[lobito]

Hi,
I’m using LibreOffice Version: 5.1.4.2, Build-ID: 1:5.1.4-0ubuntu1. My Distro is Kubuntu 16.04.
I created my first database according to one I had before with FileMaker. It is working fine so far, but now I want to improve the workflow a bit. In FileMaker I was used to the fact that there are many pedefined functions working on a selection of data sets (which of course includes “all data sets”). In Base I cannot find anything like that. Do I really have to write macros for (in my opinion) basic functions like that? Or am I just to silly to find it?
For instance I want to filter for all data sets having no invoice no. yet and then put a certain number in the field invoice no. in all of those data sets with one mouse clic or so.

I’d be very happy if someone could show me the ropes since I invested already a lot of time to find out by myself but to no avail.

Thanks in advance
lobito

[charlie.it]

In Base you can use SQL language in the Query for the functions that you need. Base engine is HSQLDB 1.8.x, search syntax on the Internet.

Edit: I think that SQL is easier than Basic, but if you want learn all of macros you can see here: http://www.pitonyak.org/OOME_3_0.pdf.

Edit 2: Here you can see a SQL handbook: http://www.1keydata.com/sql/sql.html

If my answer helped you, vote it with and with ∧ (here on the left)

[lobito]

Thanks a lot! Very good information.

[lobito]

Thanks Charlie.it! Unfortunately this is not the answer I was hoping for. Do I really have to learn SQL for something that basic? Are there no macros somewhere out there including a description an ordinary person can understand?