Created attachment 160763 [details] I am trying to create an query in LibreOffice Base because I have to do my homework. But every time I try to create queries I receive an error. I am trying to create an query in LibreOffice Base because I have to do my homework. But every time I try to create queries I receive an error.
On which LO version are you? On which env are you? (Windows, Linux, MacOs) I wonder if it could be due to Cyrillic characters, would it be possible you attach the file so I can test this?
I am on 6.0.7.3. I am using Linux (distro based on Ubuntu 18.04)
Created attachment 160769 [details] Here you are
Created attachment 160770 [details] I cannot open my previous attachment so maybe this one will open
Created attachment 160773 [details] test file
On pc Debian x86-64 with master sources updated today, I gave a try but didn't have criterion. Could you copy paste what you put in criterion?
[Введіть рік видання]
Created attachment 160775 [details] parameter query Would it correspond to what you wanted?
Created attachment 160780 [details] It doesn't work either
Ok can't help here. Uncc myself.
I can get this to work with :Введіть_рік_видання in SQL query mode (rather than GUI query design) and it will ask me for the input year.
https://wiki.documentfoundation.org/Faq/Base/115
(In reply to Alex Thurgood from comment #11) > I can get this to work with > > :Введіть_рік_видання > > in SQL query mode (rather than GUI query design) > > and it will ask me for the input year. You can save this, then switch back to GUI Query mode and the query will run, at least for me with Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 8; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded
I did the same thing and it works fine now...Thank you for your help. Do you know whether I can create a query which would create new table that would contain those fields I chose. I think it is a make table query.
"Parameter names may not contain any of the characters <space>`!"$%^*()+={}[]@'~#<>?/,. They may not be the same as field names or SQL reserved words. They may be the same as aliases." See for example : https://help.libreoffice.org/6.2/he/text/shared/explorer/database/02010100.html
(In reply to Nick from comment #14) > I did the same thing and it works fine now...Thank you for your help. Do you > know whether I can create a query which would create new table that would > contain those fields I chose. I think it is a make table query. Reading the HSQLDB documentation (for version 1.8) would be better.