[SOLVED] wild cards and parameters

peetieq2 · General User Joined: 27 Aug 2009 Posts: 6

I want to do the following thing:
I want to find all the words that contains a certain character but I want the character as a parameter, so:

letter? for instance q and then I want to find all the words with a q in it.

In MS ACCESS you can use the code:

Like '*' & [char] & '*' but that doesn't work in Open Office.

What is the correct syntax for this problem in OO?
thanks!

Sliderule · Posted: Thu Aug 27, 2009 8:30 am Post subject:

peetieq2:

Welcome to OpenOffice Base.

You are asking about using Parameter Queries.

Please see the link below, that contains both an explanation, AND, graphics on how to accomplish what you want.

http://www.oooforum.org/forum/viewtopic.phtml?t=86096

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved.

peetieq2 · General User Joined: 27 Aug 2009 Posts: 6

I'm sorry, but it doesn't work! He says that || are not allowed
I did exactly as you told: Like '%' || :char || '%'

The first part it went well: i got a popup for me parameter, but then he said that he couldn't match the input with the syntax with ||
|| not allowed, he said Crying or Very sad

Sliderule · Posted: Thu Aug 27, 2009 9:53 am Post subject:

peetieq2:

peetieq2 · General User Joined: 27 Aug 2009 Posts: 6

I use 3.1 and I tried the construction with concatenate, the result:
He recognized the parameter, but when i filled it in, he said that there was un unknown word Concat, so it doesn't work
Confused

Sliderule · Posted: Thu Aug 27, 2009 10:18 am Post subject:

peetieq2:

OK, one more question, what is the database engine you are using with OpenOffice Base?

You can confirm this, after opening your database file, by looking at the 'status bar' at the bottom.

I was assuming ( perhaps incorrectly so ), that you are using the 'default' HSQL engine.

Sliderule

peetieq2 · General User Joined: 27 Aug 2009 Posts: 6

I see at the bottom "Microsoft Access" and C:\Users\....\orgsc.mdb

, is that what you mean?

Sliderule · Posted: Thu Aug 27, 2009 11:11 am Post subject:

OK, since you are using OpenOffice with Microsoft Access as your database engine . . . this is how to accomplish your task.

In the example below, using an Access Database file, I wanted to 'search' the field Description and to prompt the user for the search string. The user will be required to also enter a % around the search string. Since, the Prompt must begine with a colon ( : ) and be one word with NO SPACES, I like to include as part of the prompt, the reminder to the user to include %. So, I used:

peetieq2 · General User Joined: 27 Aug 2009 Posts: 6

Ok, this works, but it is not the solution I aimed for Sad

What is the reason that he cannot cope with parameters and wild cards in one query?
Do you think in the future it will be possible to combine them in one expression?

Sliderule · Posted: Thu Aug 27, 2009 12:15 pm Post subject:

peetieq2:

Since, you indicated that "this works", I would appreciate it if you could please add [Solved] to your first post, as indicated at the bottom of all of my posts. This is so others searching forum posts will understand that 'a solution' has been found. Thanks.

You asked: