CHOOSE current-date

[Hamilton, Allison]

Mike - you could have accessed PowerHouse on any machine in the Hands-on Lab
or at the ADT booth in the Showcase... you were probably too busy to realise
that!   All the hands-On lab machines had PH Web and Axiant on them, as did
the machines at the booth.
Allison Hamilton

> ----------
> From: 	Michael Lee[SMTP:mcl_systems@bc.sympatico.ca]
> Sent: 	Wednesday, September 08, 1999 7:52 AM
> To: 	Johan Koelewijn
> Cc: 	Bob Feighner; powerh-l@lists.swau.edu
> Subject: 	Re: CHOOSE current-date
> 
> I don't have access to Powerhouse right now as I'm stuck here in Florida
> at the
> user conference (life's rough) but I think you can do the following:
> CHOOSE DATE-FIELD (SYSDATE)
> 
> I may be wrong on this but give it a shot.
> 
> Michael Lee
> MCL Systems Inc.
> 
> 
> Johan Koelewijn wrote:
> 
> > Hello Bob,
> >
> > You can put the value of sysdate in a systemvalue and use that
> systemvalue
> > for your choose. That's the way we do it.
> >
> > Johan Koelewijn
> > Van Dijk Delft BV
> >
> > -----Oorspronkelijk bericht-----
> > Van: Bob Feighner <bfeighnr@mailclerk.ecok.edu>
> > Aan: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
> > Datum: dinsdag 7 september 1999 23:47
> > Onderwerp: CHOOSE current-date
> >
> > >I can't believe that I haven't tried this before, but it must be the
> case.
> > >
> > >I want to use a QUIZ statement
> > >'CHOOSE A-DATE SYSDATE'
> > >where A-DATE is a key to the IMAGE detail data set residing on our
> HP3000
> > and
> > >receive this error message.
> > >
> > >*E* Expected:  @  .  GENERIC  NOGENERIC  PARM  SYSTEMVALUE  ,  (
> <number>
> > >      <eol>
> > >
> > >If I change it to
> > >'CHOOSE A-DATE 19990907', all is well.
> > >
> > >If I change it to
> > >'SELECT IF A-DATE = SYSDATE', all is well (except that it does a serial
> > read on
> > >the file.
> > >
> > >I want to run this daily without having to 'seed' the command file with
> the
> > date
> > >every time.
> > >
> > >I'm guessing that this is trivial for someone.
> > >
> > >Help, please and Thanks In Advance.
> > >
> > >Bob
> > >
> > >- Bob Feighner
> > >- Director, Computer Services
> > >- 159 Administration Building
> > >- East Central University
> > >- Ada, OK  74820
> > >- bfeighnr@mailclerk.ecok.edu
> > >- phone:   580/310-5256
> > >- FAX:     580/436-4563
> > >- http://www.ecok.edu
> > >
> > >
> > >= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> > >Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> > >Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> > >powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> > >This list is closed, thus to post to the list, you must be a
> subscriber.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> > Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> > Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> > powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> > This list is closed, thus to post to the list, you must be a subscriber.
> 
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.