Peter Haider
|
| Posted: 03/04/2004, 2:21 PM |
|
Hello Newsgroup,
i am struggeling with the query builder from CCS (latest version)
My request: to retrieve records which has value "Null" or "not equal 0" (it
is a numeric field).
How to put that in into the query builder?
Thanks and best regards
Peter Haider
|
|
|
 |
DonB
|
| Posted: 03/04/2004, 2:42 PM |
|
Do you want to do one query? One that is like: SELECT * FROM table where
value IS Null OR value <> 0
Not sure why you would be having trouble. The query builder handles this
with no problem that I can see. I clicked "+", selected the column and "is
Null", "Or" from the dropdown list, clicked OK. Clicked "+", selected the
same field, "not equal", "0" and set the type to "Expression"
Clicked OK, saved it and it looked fine.
In what way are you having trouble?
--
DonB
http://www.gotodon.com/ccbth
"Peter Haider" <peter.haider@de-integro.at> wrote in message
news:c28a5b$cgv$1@news.codecharge.com...
> Hello Newsgroup,
>
> i am struggeling with the query builder from CCS (latest version)
> My request: to retrieve records which has value "Null" or "not equal 0"
(it
> is a numeric field).
> How to put that in into the query builder?
> Thanks and best regards
> Peter Haider
>
>
|
|
|
|
Peter Haider
|
| Posted: 03/04/2004, 2:55 PM |
|
Hi DonB,
i tried it a second time and it works, god knows why...
Thanks and best regards
Peter Haider
"DonB" <~ccbth~@gotodon.com> schrieb im Newsbeitrag
news:c28bd7$fv4$1@news.codecharge.com...
> Do you want to do one query? One that is like: SELECT * FROM table where
> value IS Null OR value <> 0
>
> Not sure why you would be having trouble. The query builder handles this
> with no problem that I can see. I clicked "+", selected the column and
"is
> Null", "Or" from the dropdown list, clicked OK. Clicked "+", selected the
> same field, "not equal", "0" and set the type to "Expression"
>
> Clicked OK, saved it and it looked fine.
>
> In what way are you having trouble?
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Peter Haider" <peter.haider@de-integro.at> wrote in message
>news:c28a5b$cgv$1@news.codecharge.com...
> > Hello Newsgroup,
> >
> > i am struggeling with the query builder from CCS (latest version)
> > My request: to retrieve records which has value "Null" or "not equal 0"
> (it
> > is a numeric field).
> > How to put that in into the query builder?
> > Thanks and best regards
> > Peter Haider
> >
> >
>
>
|
|
|
|
|
