ABL Null Date Syntax for BPM

Get a (chat)room...

;-)

On Thursday, August 1, 2013, Jose Gomez wrote:

> I am not your favorite every day? *SAD FACE*
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@... <javascript:;>
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Thu, Aug 1, 2013 at 9:14 AM, brenda mohr <brenda@...<javascript:;>>
> wrote:
>
> > **
> >
> >
> > Jose - You are SO my favorite person today :D
> >
> > Brenda
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <javascript:;> [mailto:
> vantage@yahoogroups.com <javascript:;>] On Behalf
> > Of Jose Gomez
> > Sent: Thursday, August 01, 2013 9:02 AM
> > To: Vantage
> > Subject: Re: [Vantage] ABL Null Date Syntax for BPM
> >
> > Try ? instead of Null
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@... <javascript:;>
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez
> > >
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Thu, Aug 1, 2013 at 9:00 AM, brenda mohr <brenda@...<javascript:;>>
> wrote:
> >
> > > **
> >
> > >
> > >
> > > Simple Syntax question... I guess ISNULL doesn't work? Neither does
> > > JobHead.StartDate = "".
> > >
> > > FOR EACH JobHead WHERE (JobHead.Company = CUR-COMP) AND
> > > (JobHead.JobClosed = FALSE) AND (JobHead.JobComplete = FALSE) AND
> > > ISNULL(JobHead.StartDate) no-lock.
> > > /* Stuff Goes Here */
> > > END.
> > >
> > > Brenda
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]
Simple Syntax question... I guess ISNULL doesn't work? Neither does JobHead.StartDate = "".

FOR EACH JobHead WHERE (JobHead.Company = CUR-COMP) AND (JobHead.JobClosed = FALSE) AND (JobHead.JobComplete = FALSE) AND ISNULL(JobHead.StartDate) no-lock.
/* Stuff Goes Here */
END.

Brenda



[Non-text portions of this message have been removed]
Try ? instead of Null


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, Aug 1, 2013 at 9:00 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> Simple Syntax question... I guess ISNULL doesn't work? Neither does
> JobHead.StartDate = "".
>
> FOR EACH JobHead WHERE (JobHead.Company = CUR-COMP) AND (JobHead.JobClosed
> = FALSE) AND (JobHead.JobComplete = FALSE) AND ISNULL(JobHead.StartDate)
> no-lock.
> /* Stuff Goes Here */
> END.
>
> Brenda
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Jose - You are SO my favorite person today :D

Brenda

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, August 01, 2013 9:02 AM
To: Vantage
Subject: Re: [Vantage] ABL Null Date Syntax for BPM

Try ? instead of Null


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, Aug 1, 2013 at 9:00 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> Simple Syntax question... I guess ISNULL doesn't work? Neither does
> JobHead.StartDate = "".
>
> FOR EACH JobHead WHERE (JobHead.Company = CUR-COMP) AND
> (JobHead.JobClosed = FALSE) AND (JobHead.JobComplete = FALSE) AND
> ISNULL(JobHead.StartDate) no-lock.
> /* Stuff Goes Here */
> END.
>
> Brenda
>
> [Non-text portions of this message have been removed]
>
>
>


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
I am not your favorite every day? *SAD FACE*


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Thu, Aug 1, 2013 at 9:14 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> Jose - You are SO my favorite person today :D
>
> Brenda
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, August 01, 2013 9:02 AM
> To: Vantage
> Subject: Re: [Vantage] ABL Null Date Syntax for BPM
>
> Try ? instead of Null
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Thu, Aug 1, 2013 at 9:00 AM, brenda mohr <brenda@...> wrote:
>
> > **
>
> >
> >
> > Simple Syntax question... I guess ISNULL doesn't work? Neither does
> > JobHead.StartDate = "".
> >
> > FOR EACH JobHead WHERE (JobHead.Company = CUR-COMP) AND
> > (JobHead.JobClosed = FALSE) AND (JobHead.JobComplete = FALSE) AND
> > ISNULL(JobHead.StartDate) no-lock.
> > /* Stuff Goes Here */
> > END.
> >
> > Brenda
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


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