Re: [U2] OPEN Statement DICT Default

2006-05-09 Thread Mats Carlid
You mean sthg like:

FOR I=31 TO 365 STEP 28
   PRINT  (I,'DMAL')[1,3] 
   NEXT I

Tried  'DMBL'  but the abbreviations were only two characters.
But printing the actual string is somewhat shorter ...

-- mats


Mark Johnson wrote:

I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.


- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default


  

The same programmer that doesn't read the manual does an

EXECUTE instead of a SELECTINDEX, and yes, the index already existed

or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
crowd  A= B'L%20'

or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')


And yes, I have observed all of the above recently.

;)  Just 15 minutes a week to look through the current manuals to find
out about a new option that you might not know existed?

Roger

Louie Bergsagel wrote:


I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?

*:)*
-- Louie Bergsagel


On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:

  

To All:

Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and a
comma.

I accidentally forgot it in 1978 on a Microdata and it still compiled.


To
  

this
day I have not seen a reason for the OPEN ,FILE null dict indicator
and
have not used it since unless I actually want the DICT level.

Just wondering.

Thanks
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-09 Thread u2
[EMAIL PROTECTED] wrote:
 You did mean
 OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere 
 and [4,2] for the Eastern, right? ;-)
 
No 

It's [4,2] for me, and although I do live in the Eastern hemisphere - just - 
most of my country lies in the West (hint - Greenwich is five miles down the 
road, and my daily commute takes me into the West).

Cheers,
Wol

 
 Roger
 Mark Johnson wrote:
 
 I specifically remember being taught
 X=STR(0,5-LEN(X)):X
 for the 1 concept.
 Before the % was allowed, a shorter form was
 X=(0:X)R#5
 which I recall using until % came about.
 
 On that note, I stole R-10 and C#10 from UD and offered it to D3
 hopefully for their next release.
 
 Thanks
 Mark Johnson
 
 P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
 the shortest way.
 Puzzle: Illustrate the simplest way to generate Jan thru Dec.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-09 Thread Mark Johnson
My Bad, I meant [1,2], not the year part. Actually the [1,2] works for both
hemispheres if the SET-DATE command is set to either US or European. Thus
[1,2] or DM grabs the month and [4,2] or DD grabs the day.

Thanks
- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 11:05 PM
Subject: Re: [U2] OPEN Statement DICT Default


 You did mean
 OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere
 and [4,2] for the Eastern, right? ;-)


 Roger
 Mark Johnson wrote:

 I specifically remember being taught
 X=STR(0,5-LEN(X)):X
 for the 1 concept.
 Before the % was allowed, a shorter form was
 X=(0:X)R#5
 which I recall using until % came about.
 
 On that note, I stole R-10 and C#10 from UD and offered it to D3
 hopefully for their next release.
 
 Thanks
 Mark Johnson
 
 P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
 the shortest way.
 Puzzle: Illustrate the simplest way to generate Jan thru Dec.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-09 Thread Mark Johnson
That's cool. I owe Pete Colucci for this one:
FOR I=1 TO 12
   CRT (I*28)DM
NEXT I

Thanks.

- Original Message -
From: Womack, Adrian [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 11:27 PM
Subject: RE: [U2] OPEN Statement DICT Default


 All the months order (full names):

 CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL)

 Abbreviations:

 CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL[3])



 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
 Sent: Tuesday, 9 May 2006 10:50 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] OPEN Statement DICT Default

 I meant all of the months in order. Thanks.


 DISCLAIMER:
 Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and
delete the e-mail and any attachments without using or disclosing the
contents in any way. The views expressed in this e-mail are those of the
author, and do not represent those of this company unless this is clearly
indicated. You should scan this e-mail and any attachments for viruses. This
company accepts no liability for any direct or indirect damage or loss
resulting from the use of any attachments to this e-mail.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-09 Thread Mark Johnson
Mats: You'll like my (I*28) a little cleaner.
- Original Message -
From: Mats Carlid [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, May 09, 2006 2:34 AM
Subject: Re: [U2] OPEN Statement DICT Default


 You mean sthg like:

 FOR I=31 TO 365 STEP 28
PRINT  (I,'DMAL')[1,3]
NEXT I

 Tried  'DMBL'  but the abbreviations were only two characters.
 But printing the actual string is somewhat shorter ...

 -- mats


 Mark Johnson wrote:

 I specifically remember being taught
 X=STR(0,5-LEN(X)):X
 for the 1 concept.
 Before the % was allowed, a shorter form was
 X=(0:X)R#5
 which I recall using until % came about.
 
 On that note, I stole R-10 and C#10 from UD and offered it to D3
 hopefully for their next release.
 
 Thanks
 Mark Johnson
 
 P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
 the shortest way.
 Puzzle: Illustrate the simplest way to generate Jan thru Dec.
 
 
 - Original Message -
 From: Roger Glenfield [EMAIL PROTECTED]
 To: u2-users@listserver.u2ug.org
 Sent: Monday, May 08, 2006 9:42 AM
 Subject: Re: [U2] OPEN Statement DICT Default
 
 
 
 
 The same programmer that doesn't read the manual does an
 
 EXECUTE instead of a SELECTINDEX, and yes, the index already existed
 
 or
 A=STR('0',20-LEN(B)):B
 instead of
 A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
 crowd  A= B'L%20'
 
 or
 TODAY=OCONV(DATE(),'D2/')
 CONVERT '/' TO @VM IN TODAY
 MONTH=TODAY1,2
 instead of
 MONTH=OCONV(DATE(),'DM')
 
 
 And yes, I have observed all of the above recently.
 
 ;)  Just 15 minutes a week to look through the current manuals to find
 out about a new option that you might not know existed?
 
 Roger
 
 Louie Bergsagel wrote:
 
 
 I've never used the null dict indicator. Who ever reads the syntax book
 unless a command doesn't work?
 
 *:)*
 -- Louie Bergsagel
 
 
 On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
 
 
 
 To All:
 
 Was there ever a real requirement on any prior flavor to have the
 typically
 non-used DICT portion of the OPEN statement be the set of quotes and a
 comma.
 
 I accidentally forgot it in 1978 on a Microdata and it still compiled.
 
 
 To
 
 
 this
 day I have not seen a reason for the OPEN ,FILE null dict
indicator
 and
 have not used it since unless I actually want the DICT level.
 
 Just wondering.
 
 Thanks
 Mark Johnson
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 
 
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 
 
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] OPEN Statement DICT Default

2006-05-09 Thread Eppel,Gary
Wow - didn't know Canada had moved to the Eastern Hemisphere!!? See,
that's what happens when I don't keep up with events in my home country.
;)

Actually, I think the US is the only place still using mm/dd/yy, east or
west. But I could be wrong.

Gary
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield
Sent: Monday, May 08, 2006 10:05 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] OPEN Statement DICT Default

You did mean
OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere
and [4,2] for the Eastern, right? ;-)


Roger
Mark Johnson wrote:

I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think
DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

-
CONFIDENTIALITY NOTICE This message and any included attachments
are from Cerner Corporation and are intended only for the
addressee. The information contained in this message is
confidential and may constitute inside or non-public information
under international, federal, or state securities laws.
Unauthorized forwarding, printing, copying, distribution, or use of
such information is strictly prohibited and may be unlawful. If you
are not the addressee, please promptly delete this message and
notify the sender of the delivery error by e-mail or you may call
Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1)
(816)221-1024. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-08 Thread Roger Glenfield

The same programmer that doesn't read the manual does an

EXECUTE instead of a SELECTINDEX, and yes, the index already existed

or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the 
crowd  A= B'L%20'


or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')


And yes, I have observed all of the above recently.

;)  Just 15 minutes a week to look through the current manuals to find 
out about a new option that you might not know existed?


Roger

Louie Bergsagel wrote:

I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?

*:)*
-- Louie Bergsagel


On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
  

To All:

Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and a
comma.

I accidentally forgot it in 1978 on a Microdata and it still compiled. To
this
day I have not seen a reason for the OPEN ,FILE null dict indicator
and
have not used it since unless I actually want the DICT level.

Just wondering.

Thanks
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-08 Thread Mark Johnson
I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.


- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default


 The same programmer that doesn't read the manual does an

 EXECUTE instead of a SELECTINDEX, and yes, the index already existed

 or
 A=STR('0',20-LEN(B)):B
 instead of
 A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
 crowd  A= B'L%20'

 or
 TODAY=OCONV(DATE(),'D2/')
 CONVERT '/' TO @VM IN TODAY
 MONTH=TODAY1,2
 instead of
 MONTH=OCONV(DATE(),'DM')

 
 And yes, I have observed all of the above recently.

 ;)  Just 15 minutes a week to look through the current manuals to find
 out about a new option that you might not know existed?

 Roger

 Louie Bergsagel wrote:
  I've never used the null dict indicator. Who ever reads the syntax book
  unless a command doesn't work?
 
  *:)*
  -- Louie Bergsagel
 
 
  On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
 
  To All:
 
  Was there ever a real requirement on any prior flavor to have the
  typically
  non-used DICT portion of the OPEN statement be the set of quotes and a
  comma.
 
  I accidentally forgot it in 1978 on a Microdata and it still compiled.
To
  this
  day I have not seen a reason for the OPEN ,FILE null dict indicator
  and
  have not used it since unless I actually want the DICT level.
 
  Just wondering.
 
  Thanks
  Mark Johnson
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-08 Thread Adrian Overs
Solution to puzzle :
Month = OCONV(DATE(),DMBL)
D = Date
MB = Abbreviated Month Name
L = Lower Case


On 9/5/06 9:45 AM, Mark Johnson [EMAIL PROTECTED] wrote:

 I specifically remember being taught
 X=STR(0,5-LEN(X)):X
 for the 1 concept.
 Before the % was allowed, a shorter form was
 X=(0:X)R#5
 which I recall using until % came about.
 
 On that note, I stole R-10 and C#10 from UD and offered it to D3
 hopefully for their next release.
 
 Thanks
 Mark Johnson
 
 P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
 the shortest way.
 Puzzle: Illustrate the simplest way to generate Jan thru Dec.
 
 
 - Original Message -
 From: Roger Glenfield [EMAIL PROTECTED]
 To: u2-users@listserver.u2ug.org
 Sent: Monday, May 08, 2006 9:42 AM
 Subject: Re: [U2] OPEN Statement DICT Default
 
 
 The same programmer that doesn't read the manual does an
 
 EXECUTE instead of a SELECTINDEX, and yes, the index already existed
 
 or
 A=STR('0',20-LEN(B)):B
 instead of
 A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
 crowd  A= B'L%20'
 
 or
 TODAY=OCONV(DATE(),'D2/')
 CONVERT '/' TO @VM IN TODAY
 MONTH=TODAY1,2
 instead of
 MONTH=OCONV(DATE(),'DM')
 
 
 And yes, I have observed all of the above recently.
 
 ;)  Just 15 minutes a week to look through the current manuals to find
 out about a new option that you might not know existed?
 
 Roger
 
 Louie Bergsagel wrote:
 I've never used the null dict indicator. Who ever reads the syntax book
 unless a command doesn't work?
 
 *:)*
 -- Louie Bergsagel
 
 
 On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
 
 To All:
 
 Was there ever a real requirement on any prior flavor to have the
 typically
 non-used DICT portion of the OPEN statement be the set of quotes and a
 comma.
 
 I accidentally forgot it in 1978 on a Microdata and it still compiled.
 To
 this
 day I have not seen a reason for the OPEN ,FILE null dict indicator
 and
 have not used it since unless I actually want the DICT level.
 
 Just wondering.
 
 Thanks
 Mark Johnson
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 

-- 
Adrian Overs
Phone : +61 (0)2 9484-7160
Mobile: +61 (0)411 358 354
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] OPEN Statement DICT Default

2006-05-08 Thread Bob Woodward
PRINT
JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC

I WIN!!!  GIGGLE

BobW
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Monday, May 08, 2006 4:46 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] OPEN Statement DICT Default

I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.


- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default


 The same programmer that doesn't read the manual does an

 EXECUTE instead of a SELECTINDEX, and yes, the index already
existed

 or
 A=STR('0',20-LEN(B)):B
 instead of
 A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
 crowd  A= B'L%20'

 or
 TODAY=OCONV(DATE(),'D2/')
 CONVERT '/' TO @VM IN TODAY
 MONTH=TODAY1,2
 instead of
 MONTH=OCONV(DATE(),'DM')

 
 And yes, I have observed all of the above recently.

 ;)  Just 15 minutes a week to look through the current manuals to find
 out about a new option that you might not know existed?

 Roger

 Louie Bergsagel wrote:
  I've never used the null dict indicator. Who ever reads the syntax
book
  unless a command doesn't work?
 
  *:)*
  -- Louie Bergsagel
 
 
  On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
 
  To All:
 
  Was there ever a real requirement on any prior flavor to have the
  typically
  non-used DICT portion of the OPEN statement be the set of quotes
and a
  comma.
 
  I accidentally forgot it in 1978 on a Microdata and it still
compiled.
To
  this
  day I have not seen a reason for the OPEN ,FILE null dict
indicator
  and
  have not used it since unless I actually want the DICT level.
 
  Just wondering.
 
  Thanks
  Mark Johnson
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-08 Thread Mark Johnson
I meant all of the months in order. Thanks.
- Original Message -
From: Adrian Overs [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:53 PM
Subject: Re: [U2] OPEN Statement DICT Default


 Solution to puzzle :
 Month = OCONV(DATE(),DMBL)
 D = Date
 MB = Abbreviated Month Name
 L = Lower Case


 On 9/5/06 9:45 AM, Mark Johnson [EMAIL PROTECTED] wrote:

  I specifically remember being taught
  X=STR(0,5-LEN(X)):X
  for the 1 concept.
  Before the % was allowed, a shorter form was
  X=(0:X)R#5
  which I recall using until % came about.
 
  On that note, I stole R-10 and C#10 from UD and offered it to D3
  hopefully for their next release.
 
  Thanks
  Mark Johnson
 
  P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
  the shortest way.
  Puzzle: Illustrate the simplest way to generate Jan thru Dec.
 
 
  - Original Message -
  From: Roger Glenfield [EMAIL PROTECTED]
  To: u2-users@listserver.u2ug.org
  Sent: Monday, May 08, 2006 9:42 AM
  Subject: Re: [U2] OPEN Statement DICT Default
 
 
  The same programmer that doesn't read the manual does an
 
  EXECUTE instead of a SELECTINDEX, and yes, the index already
existed
 
  or
  A=STR('0',20-LEN(B)):B
  instead of
  A=FMT(B,'L%20')   or for the Universe Pick/Ideal flavor people in the
  crowd  A= B'L%20'
 
  or
  TODAY=OCONV(DATE(),'D2/')
  CONVERT '/' TO @VM IN TODAY
  MONTH=TODAY1,2
  instead of
  MONTH=OCONV(DATE(),'DM')
 
  
  And yes, I have observed all of the above recently.
 
  ;)  Just 15 minutes a week to look through the current manuals to find
  out about a new option that you might not know existed?
 
  Roger
 
  Louie Bergsagel wrote:
  I've never used the null dict indicator. Who ever reads the syntax
book
  unless a command doesn't work?
 
  *:)*
  -- Louie Bergsagel
 
 
  On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
 
  To All:
 
  Was there ever a real requirement on any prior flavor to have the
  typically
  non-used DICT portion of the OPEN statement be the set of quotes and
a
  comma.
 
  I accidentally forgot it in 1978 on a Microdata and it still
compiled.
  To
  this
  day I have not seen a reason for the OPEN ,FILE null dict
indicator
  and
  have not used it since unless I actually want the DICT level.
 
  Just wondering.
 
  Thanks
  Mark Johnson
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
  ---
  u2-users mailing list
  u2-users@listserver.u2ug.org
  To unsubscribe please visit http://listserver.u2ug.org/
 

 --
 Adrian Overs
 Phone : +61 (0)2 9484-7160
 Mobile: +61 (0)411 358 354
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-08 Thread Roger Glenfield

You did mean
OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere 
and [4,2] for the Eastern, right? ;-)



Roger
Mark Johnson wrote:


I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.

On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.

Thanks
Mark Johnson

P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] OPEN Statement DICT Default

2006-05-08 Thread Womack, Adrian
All the months order (full names):

CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL) 

Abbreviations:

CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL[3]) 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Tuesday, 9 May 2006 10:50 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] OPEN Statement DICT Default

I meant all of the months in order. Thanks.


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] OPEN Statement DICT Default

2006-05-06 Thread Kevin King
Early versions of Reality did require it, including PC-MicroReality. 


-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: Friday, May 05, 2006 10:37 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OPEN Statement DICT Default

To All:

Was there ever a real requirement on any prior flavor to have the
typically non-used DICT portion of the OPEN statement be the set of
quotes and a comma.

I accidentally forgot it in 1978 on a Microdata and it still compiled.
To this day I have not seen a reason for the OPEN ,FILE null dict
indicator and have not used it since unless I actually want the DICT
level.

Just wondering.

Thanks
Mark Johnson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date:
5/5/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-06 Thread Mark Johnson
It's a shame that the habit wasn't broken when it became optional.
Thanks.
- Original Message - 
From: Kevin King [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Saturday, May 06, 2006 11:06 AM
Subject: RE: [U2] OPEN Statement DICT Default


 Early versions of Reality did require it, including PC-MicroReality. 
 
 
 -Kevin
 [EMAIL PROTECTED]
 http://www.PrecisOnline.com
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
 Sent: Friday, May 05, 2006 10:37 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] OPEN Statement DICT Default
 
 To All:
 
 Was there ever a real requirement on any prior flavor to have the
 typically non-used DICT portion of the OPEN statement be the set of
 quotes and a comma.
 
 I accidentally forgot it in 1978 on a Microdata and it still compiled.
 To this day I have not seen a reason for the OPEN ,FILE null dict
 indicator and have not used it since unless I actually want the DICT
 level.
 
 Just wondering.
 
 Thanks
 Mark Johnson
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 
 --
 No virus found in this incoming message.
 Checked by AVG Free Edition.
 Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date:
 5/5/2006
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OPEN Statement DICT Default

2006-05-05 Thread Louie Bergsagel
I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?

*:)*
-- Louie Bergsagel


On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:

 To All:

 Was there ever a real requirement on any prior flavor to have the
 typically
 non-used DICT portion of the OPEN statement be the set of quotes and a
 comma.

 I accidentally forgot it in 1978 on a Microdata and it still compiled. To
 this
 day I have not seen a reason for the OPEN ,FILE null dict indicator
 and
 have not used it since unless I actually want the DICT level.

 Just wondering.

 Thanks
 Mark Johnson
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/