MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 1999

Re: Ldate and opnqryf question


  • Subject: Re: Ldate and opnqryf question
  • From: "Wayne Achenbaum" <wache@xxxxxxxxxxx>
  • Date: Sat, 1 May 1999 15:38:39 -0400

fixed

Thanks Art. This one I posted for an Ex-coworker. I myself have no date
formats stored in my database, so I had no idea, but was curious as to the
answer. This answer seems straight forward and I will pass it on to my
friend in need.
Thanks again.

----- Original Message -----
From: Art Tostaine, Jr. <art@link400.com>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, April 30, 1999 7:37 PM
Subject: RE: Ldate and opnqryf question


> I use this for my QRYSLT when using a field DATEL from my database file
and &DATEPARM from CLP:
>
> QRYSLT('DATEL *EQ "' *CAT &DATEPARM *TCAT '"')
>
> I prefer the double-quote over multiple single quotes (ticks)
>
> BTW, a fellow programmer who came out of Cittone Institute here in NJ was
the first one to use the
> "tick".  I think it sounds nuts to say "tick".  He also says "Splat" for
asterisk!
>
>
> Art Tostaine, Jr.
> CCA, Inc.
> Parlin, NJ  08859
>
>
> > -----Original Message-----
> > From: owner-midrange-l@midrange.com
> > [mailto:owner-midrange-l@midrange.com]On Behalf Of Buck Calabro
> > Sent: Friday, April 30, 1999 5:49 PM
> > To: 'MIDRANGE-L@midrange.com'
> > Subject: RE: Ldate and opnqryf question
> >
> >
> > OPNQRYF FILE((PROMAS)) QRYSLT('PROMASDATE *GE ''1999-01-01''')
> >
> > I used all single tick marks - no double quotes.
> >
> > Buck Calabro
> >
> > > -----Original Message-----
> > > From: Wayne Achenbaum
> > > Sent: Friday, April 30, 1999 1:28 PM
> > > To: MIDRANGE-L@midrange.com
> > > Subject: Ldate and opnqryf question
> > >
> > > Does anyone know how to compare a program variable against
> > a physicla
> > > file Ldate field(i.e. *iso)? TIA
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> > david@midrange.com
> > +---
> >
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact