| View previous topic :: View next topic |
| Author |
Message |
manuelprado
Newbie
Joined: 30 Jul 2009
Posts: 2
|
 Posted: Thu Jul 30, 2009 11:27 am Post subject: using wizard to create query |
 |
|
Hello, I am new to oo and have never programmed in sql. I have been able to get around a bit doing queries with the wizard. Unfortunately, the criteria is very limited. I am able to do things such as "is equal to" or "less than" but I can't seem to find out how to do a query using the wizard that simply sets the criteria as "containing".
I have read other threads where sql code is suggested but I have no idea how to do that and as such would prefer to continue using the query wizard.
Any help would be greatly appreciated.
Manuel |
|
| Back to top |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Thu Jul 30, 2009 11:45 am Post subject: |
|
|
Manuel:
Welcome to OpenOffice Base.
You said: | Manuel wrote: | | I am able to do things such as "is equal to" or "less than" but I can't seem to find out how to do a query using the wizard that simply sets the criteria as "containing". |
The link below gives an explanation ( response from Sliderule ) of how to create a Query that I think will meet your needs / criterion. It includes 'graphics' with step-by-step instructions on a technique to create a Query - using LIKE to meet your "containing" needs.
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. |
|
| Back to top |
|
|
manuelprado
Newbie
Joined: 30 Jul 2009
Posts: 2
|
| Posted: Thu Jul 30, 2009 1:49 pm Post subject: thanks... almost there... |
|
|
Ok, that should do it... I have one other question along the same lines. How do you set the criteria as "not blank".
Thanks again for your help. |
|
| Back to top |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Thu Jul 30, 2009 2:02 pm Post subject: |
|
|
Manuel:
You asked: | Manuel wrote: | | I have one other question along the same lines. How do you set the criteria as "not blank". |
Answer: on the Criterion line, enter:
| Code: | IS NOT EMPTY
OR, to determine IF it is NULL, USE
IS EMPTY |
Just to be clear, well, as clear as mud, this is saying . . . the contents are NOT NULL.
On the other hand, if the field was given a value -- with a length of ZERO characters ( rather than NULL ) . . . it should be entered as:
above is '' . . . TWO Single Quotes, since, data BETWEEN two single quotes are TEXT LITERAL. Therefore, a TEXT LITERAL of zero length is denoted as '' .
For additional information on the topic, you can check the Base Help File ( F1 ) with the topic of:
criteria of query design (Base)
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.[/code] |
|
| Back to top |
|
|
|
