My BAQ to find blank bins did not work with " NULL", but did wor

Sorry I meant comparing them to eg customer.number01 or whatever number field in the table.

Chris Thompson

On 13 Jun 2013, at 12:01, brenda mohr <brenda@...> wrote:

> I have run into this in the past and checking for the ASCII seem to work. The ones I tend to use are
> CHR(032) –Space
> CHR(127) – Delete (This is usually the culprit in my cases)
>
> Brenda
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
> Sent: Wednesday, June 12, 2013 2:52 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] My BAQ to find blank bins did not work with " NULL", but did work with < "-".
>
>
>
> Did you try comparing it to a character field or number field?
>
> Chris Thompson
>
> On 12 Jun 2013, at 18:00, "Len Hartka" <len.hartka@...<mailto:len.hartka%40sunautomation.com>> wrote:
>
> > Good Day:
> >
> > My BAQ to find blank bins did not work with " NULL", but did
> > work with < "-".
> >
> > Does that mean there is ""Some non-displaying thing" in the
> > field. How do I get its ASSCII code - or 'see' it.
> >
> > Len
> >
> > This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
Good Day:





My BAQ to find blank bins did not work with " NULL", but did
work with < "-".



Does that mean there is ""Some non-displaying thing" in the
field. How do I get its ASSCII code - or 'see' it.




Len





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
What about: =""







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Len Hartka
Sent: Wednesday, June 12, 2013 1:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] My BAQ to find blank bins did not work with " NULL", but
did work with < "-".





Good Day:

My BAQ to find blank bins did not work with " NULL", but did
work with < "-".

Does that mean there is ""Some non-displaying thing" in the
field. How do I get its ASSCII code - or 'see' it.

Len

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Null refers to a date... I believe...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, June 12, 2013 1:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] My BAQ to find blank bins did not work with " NULL", but did work with < "-".



Good Day:

My BAQ to find blank bins did not work with " NULL", but did
work with < "-".

Does that mean there is ""Some non-displaying thing" in the
field. How do I get its ASSCII code - or 'see' it.

Len

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Good Day Vic:



I can display the record.

It displays as a null, but IS NULL will not bring it back.



More testing shows: only finds the record. IF

Bin = Constant and the constant is either null or
space-bar.

Why doesn't IS NULL work?




Len





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Wednesday, June 12, 2013 1:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] My BAQ to find blank bins did not work with "
NULL", but did work with < "-".





What about: =""

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Wednesday, June 12, 2013 1:00 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] My BAQ to find blank bins did not work with " NULL",
but
did work with < "-".

Good Day:

My BAQ to find blank bins did not work with " NULL", but did
work with < "-".

Does that mean there is ""Some non-displaying thing" in the
field. How do I get its ASSCII code - or 'see' it.

Len

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
Did you try using the constant of ''?



For some reason I find that blank fields in Progress are spaces not nulls.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Len Hartka
Sent: Wednesday, June 12, 2013 11:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] My BAQ to find blank bins did not work with " NULL",
but did work with < "-".





Good Day Vic:

I can display the record.

It displays as a null, but IS NULL will not bring it back.

More testing shows: only finds the record. IF

Bin = Constant and the constant is either null or
space-bar.

Why doesn't IS NULL work?

Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Wednesday, June 12, 2013 1:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] My BAQ to find blank bins did not work with "
NULL", but did work with < "-".

What about: =""

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Len Hartka
Sent: Wednesday, June 12, 2013 1:00 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] My BAQ to find blank bins did not work with " NULL",
but
did work with < "-".

Good Day:

My BAQ to find blank bins did not work with " NULL", but did
work with < "-".

Does that mean there is ""Some non-displaying thing" in the
field. How do I get its ASSCII code - or 'see' it.

Len

This e-mail and any attachments may contain proprietary and/or
confidential
information. If you are not the intended recipient, please notify the
sender
immediately by reply e-mail or at 410-472-2900 and then delete the
message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

This e-mail and any attachments may contain proprietary and/or confidential
information. If you are not the intended recipient, please notify the sender
immediately by reply e-mail or at 410-472-2900 and then delete the message
without using, disseminating, or copying this message or any portion
thereof. With e-mail communications you are urged to protect against
viruses.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Did you try comparing it to a character field or number field?

Chris Thompson

On 12 Jun 2013, at 18:00, "Len Hartka" <len.hartka@...> wrote:

> Good Day:
>
> My BAQ to find blank bins did not work with " NULL", but did
> work with < "-".
>
> Does that mean there is ""Some non-displaying thing" in the
> field. How do I get its ASSCII code - or 'see' it.
>
> Len
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]
I have run into this in the past and checking for the ASCII seem to work. The ones I tend to use are
CHR(032) –Space
CHR(127) – Delete (This is usually the culprit in my cases)

Brenda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, June 12, 2013 2:52 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] My BAQ to find blank bins did not work with " NULL", but did work with < "-".



Did you try comparing it to a character field or number field?

Chris Thompson

On 12 Jun 2013, at 18:00, "Len Hartka" <len.hartka@...<mailto:len.hartka%40sunautomation.com>> wrote:

> Good Day:
>
> My BAQ to find blank bins did not work with " NULL", but did
> work with < "-".
>
> Does that mean there is ""Some non-displaying thing" in the
> field. How do I get its ASSCII code - or 'see' it.
>
> Len
>
> This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]