Page 1 of 1
[Solved] Bit off topic, but do not where to ask about DBeaver
Posted: Sun Jul 31, 2022 4:38 am
by dreamquartz
Hello All,
I use terms like
all the time in LO with a Split DataBase, but it appears not the correct syntax for DBeaver SQL
2 questions therefore:
1. Does anyone know where to ask questions about DBeaver?
2. Does anyone know the right syntax for
in DBeaver?
Thanks in advance,
Dream
Re: Bit of topic, but do not where to ask about DBeaver
Posted: Sun Jul 31, 2022 6:14 am
by robleyd
A quick look with a search engine, and I found their Wiki page suggests
"For technical support, feature suggestions and any other questions, please use our GitHub Issue tracker"
Re: Bit of topic, but do not where to ask about DBeaver
Posted: Sun Jul 31, 2022 9:06 am
by Mountaineer
Try
and check, if the program supports :Param
It may also depend on your database, as with Base.
You could use your code with Base+hsqldb but it would fail for Base+dbf/dBase
Re: Bit of topic, but do not where to ask about DBeaver
Posted: Sun Jul 31, 2022 1:33 pm
by Villeroy
HSQL does not support :named_parameters. This is a Base thing.
Re: Bit of topic, but do not where to ask about DBeaver
Posted: Sun Jul 31, 2022 4:36 pm
by Mountaineer
Villeroy wrote: ↑Sun Jul 31, 2022 1:33 pm
... This is a Base thing.
and also found in the docs for DBeaver (searched it via google), so now my "bet" is on using concat...
Re: Bit off topic, but do not where to ask about DBeaver
Posted: Wed Aug 03, 2022 8:01 pm
by dreamquartz
Apparently the input must be something like: 'Name', therefore input between single quotes.
I can even use all variations for input into a single table.
I am now trying to figure out how to use multiple tables for user input, because I need to be able to search on Address, CompanyName, EmailAddress, PhoneFax Numbers, and the lot.
Dream
Re: [SOLVED] Bit off topic, but do not where to ask about DBeaver
Posted: Sat Aug 13, 2022 6:33 am
by dreamquartz
My original question has been answered.
Thank you all.
Dream