Ask Your Question
0

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

asked 2016-08-07 12:02:34 +0200

lobito gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by charlie.it
close date 2016-08-22 07:21:21.935695

2 Answers

Sort by » oldest newest most voted
0

answered 2016-08-07 13:37:07 +0200

updated 2016-08-15 09:08:13 +0200

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)

edit flag offensive delete link more

Comments

Thanks a lot! Very good information.

lobito gravatar imagelobito ( 2016-08-20 16:44:07 +0200 )edit
0

answered 2016-08-14 17:12:22 +0200

lobito gravatar image

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?

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-08-07 12:02:34 +0200

Seen: 50 times

Last updated: Aug 15 '16