[Solved] Bit off topic, but do not where to ask about DBeaver

[dreamquartz]

Hello All,

I use terms like

Code: Select all

LIKE '%' || :Employee || '%'

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

Code: Select all

LIKE '%' || :Employee || '%'

in DBeaver?

Thanks in advance,

Dream

[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"

[Mountaineer]

Try

Code: Select all

concat('%',:Employee, '%')

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

[Villeroy]

HSQL does not support :named_parameters. This is a Base thing.

[Mountaineer]

... 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...

[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

[dreamquartz]

My original question has been answered.

Thank you all.

Dream