Business Activity Query - Select JobHead where TravelerLastPrin

Yahoo Archive
1
Sorry, my previous answer applied to versions 3.0 to 6.1, not 8.0,
althought it still applies to OpenEdge code on 8.x. And on data entry
in 8.x, you can highlight the date and use the Del key instead of
the ? key.

But Mark's method works if you use an unset date field from a
different table, like JobHead.TravelerLastPrinted = Company.Date20.

--- In vantage@yahoogroups.com, "jmpratt7" <james.pratt@...> wrote:
>
> In response to Cynthia Lombardo, the query is not allowed because
> TravelerLastPrinted is of type Date whereas "" is a string. This
> comparison is not allowed.
>
> In response to Mark Wonsil, this is the answer Epicor gave me which
> is logical, except it doesn't work. After several attempts, we
went
> back to Epicor who agreed it didn't work but hasn't provided an
> answer yet.
>
> If you have a tested solution please let me know.
>
> Today I tried to find records with a date prior to our go-live date
> on the asumption that records with no date are sorted prior to
> records with our go-live date. I was unable to construct a
criteria
> where TravelerLastPrinted < 11/28/2006. The phrase came out
like ...
> (TravelerLastPrinted < )... which returns no records. I appreciate
> any help.
>
> Jim Pratt
>
> --- In vantage@yahoogroups.com, "Cynthia Lombardo" <clombardo@>
> wrote:
> >
> > for null use " "
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Mark Wonsil
> > Sent: Saturday, December 16, 2006 8:15 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Business Activity Query - Select JobHead
> where
> > TravelerLastPrinted = Null
> >
> >
> >
> > > There doesn't seem to be a way to select records using a
business
> > > activity query that selects based on a Null date field. Does
> anyone
> > > have a solution to this problem?
> >
> > Kind of cheesy, but you can select another date in the JobHead
> record
> > that you
> > know is also unset, say like the last user-defined date: Date20.
> >
> > Mark W.
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
There doesn't seem to be a way to select records using a business
activity query that selects based on a Null date field. Does anyone
have a solution to this problem?
3
> There doesn't seem to be a way to select records using a business
> activity query that selects based on a Null date field. Does anyone
> have a solution to this problem?

Kind of cheesy, but you can select another date in the JobHead record that you
know is also unset, say like the last user-defined date: Date20.

Mark W.
4
Use ? for testing date fields, like "JobHead.TravelerLastPrinted = ?".
You can also use the ? on data entry to unset the field.


--- In vantage@yahoogroups.com, "jmpratt7" <james.pratt@...> wrote:
>
> There doesn't seem to be a way to select records using a business
> activity query that selects based on a Null date field. Does anyone
> have a solution to this problem?
>




[Non-text portions of this message have been removed]
5
for null use " "


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Saturday, December 16, 2006 8:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query - Select JobHead where
TravelerLastPrinted = Null



> There doesn't seem to be a way to select records using a business
> activity query that selects based on a Null date field. Does anyone
> have a solution to this problem?

Kind of cheesy, but you can select another date in the JobHead record
that you
know is also unset, say like the last user-defined date: Date20.

Mark W.






[Non-text portions of this message have been removed]
6
In response to Cynthia Lombardo, the query is not allowed because
TravelerLastPrinted is of type Date whereas "" is a string. This
comparison is not allowed.

In response to Mark Wonsil, this is the answer Epicor gave me which
is logical, except it doesn't work. After several attempts, we went
back to Epicor who agreed it didn't work but hasn't provided an
answer yet.

If you have a tested solution please let me know.

Today I tried to find records with a date prior to our go-live date
on the asumption that records with no date are sorted prior to
records with our go-live date. I was unable to construct a criteria
where TravelerLastPrinted < 11/28/2006. The phrase came out like ...
(TravelerLastPrinted < )... which returns no records. I appreciate
any help.

Jim Pratt

--- In vantage@yahoogroups.com, "Cynthia Lombardo" <clombardo@...>
wrote:
>
> for null use " "
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Mark Wonsil
> Sent: Saturday, December 16, 2006 8:15 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Business Activity Query - Select JobHead
where
> TravelerLastPrinted = Null
>
>
>
> > There doesn't seem to be a way to select records using a business
> > activity query that selects based on a Null date field. Does
anyone
> > have a solution to this problem?
>
> Kind of cheesy, but you can select another date in the JobHead
record
> that you
> know is also unset, say like the last user-defined date: Date20.
>
> Mark W.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>