Apart from building a few databases with FileMaker(Claris) a long time ago, I don’t have any programming or SQL-skills.
Thanks to the answer of @Ratslinger to my previous question, I have been able to create a working LibreOffice Base which displays now all the 1635 recipe records. (with 3 CLOB [ BLOB ] fields because of lots of text and pictures in a BLOB [ BLOB ] field)
I thought my job was finished, but I was disappointed when I noticed that the looking glass icon in the form did not do what I expected it to do. I’ve been reading in the LibreOffice 6.3 Help Query Design section, but being an SQL-illiterate I don’t understand much of it.
Is it possible to query a form in LibreOffice on all fields simultaneously with user input? (Like "Cmd-F in FileMaker) If so, how complicated is it for me as an SQL illiterate? (but absolutely wanting to learn)
Although I may have at some time used FileMaker, I have no real recollection of its’ operation. You should not guess that others are familiar with the process either. Rather be specific with the request. It appears you want to search through ALL fields in a table looking for some value. This can be costly with large BLOB fields. Can you be more specific on this process you want to accomplish? SQL is a must know when working with databases. It can alleviate many situations. Here is one site (there are many) which may help → SQL Tutorial
Thanks for the link, I will surely look into that.
You 're right, I want to give the user ((1.) my wife and (.2) myself) the opportunity to search through fields in the base table looking for user defined wildcard value for one CLOB [ BLOB ] field - if needed in combination with user defined wildcard value in another CLOB [ BLOB ] field and/or Text [ VARCHAR ] field and/or Check Box field. The “Wildcard” element is important here, I need %.
I now understand that this might be way too ambitious for me and that it would be better to start creating a query which already does the job for one CLOB [ BLOB ] field (with user input), so that I can copy it to use it for other CLOB [ BLOB ] field queries.
Do I need to create a specific “query form” for that, or can in I implement the query in the form which is now beautifully displaying all the records?
What do you mean with "This can be costly with large CLOB [ BLOB ] fields?
Thanks for anyone’s input!
What you are asking is a fairly broad subject. There are popular methods for searching data - using
LIKE in SQL and table filtering or a combination of both. Have posted many, many samples on this site related to table filtering and using wild cards in SQL. Here are a couple of related links:
These posts contain samples and links to further posts which will take some time to absorb. Included is using SQL wildcards and table filtering. Method used depends on actual needs.
As for ‘costly’ comment, with multiple BLOB fields (can be a large amount of data in each) and a number of records, this can be time consuming searching through all this only to find, depending on the search method, results not wanted. Then you start over.
@Ratslinger: Thanks! I got a few challenges in front of me.
If you run into trouble, ask a new question with some specifics on what the problem is and what you are trying to accomplish. Always include OS, specific LO version and database being used. Samples are always helpful. Screenshots not so much.
Questions always welcome.
@Ratslinger Thanks! I’m calculating some time to absorb, I hope the Mrs. will be able to do the same. I’ll be back with specifics on problems I encounter, including OS, LO version and DB being used.