DreamWriter data selection question


I have a user that is printing labels from the address book and is using the
vanilla program. In the DW version, she is selecting address book numbers
and putting *VALUE in the selection value and this takes you to the values
entry screen. Is there a limitation as to how many entries you can put in
on that screen. The user says previously she paged down and entered more
address numbers. Now when she pages down it goes back to the Data Selection
screen which is now blank. When I try this it happens the same way. I
got around this by adding the address number field again to the data
selection screen with *VALUES and this give me another screen to add more
values, but I am questioning if the user previously did page down. I don't
think a vanilla program would work that way and then not unless some changes
or versions were updated. They weren't. I looked in the manuals and they
don't go into that much detail as to how many screens or entries are
available in the values entry screen. Any info would be helpful.


The values for *VALUE are stored in file F9831. There are only 45 values
possible. I don't think the user ever paged down on the selection screen.
Never heard of this this DW selection Paging Down.... Max is as per screen
(27 ?)

Could try 'OR' but remember to repeat the other Data selections in an


Gareth Jones

ADAT Software Ltd

----- Original Message -----
From: "doddsf" <FDodds@weichertrealtors.net>
To: <jdeworldml@jdelist.com>
Sent: Monday, June 04, 2001 9:58 PM
Subject: DreamWriter data selection question



I've always thought you could only enter a maximum of 40 values per

Andy Klee

Klee Associates, Inc.
J.D. Edwards Certified Professional
Phone: 970.856.4811
Cellular: 303.591.7344
45 values is the limit. You are correct in your statement that by adding the
address number field to the data selection again, and using the same logic,
it will provide the option to enter another 45 values. Is it possible that
the user's DREAMWriter was set up with the additional line and when they
completed the first 45 values they hit he enter key and was prompted to add
up to another 45 values. In my 13 years of experience with JDE I don't
recall being able to page down after adding more than 45 values.

Sandra Scribner
Manager, Consulting Services
SCB Enterprise Solutions
401-421-9910, ext. 16


VIP Member
I just tested this and as SScribner mentioned, the limit "per *VALUE" entry is 45 values BUT you can add the selection field again (so you have 2 in your Data Selection screen) for the field you are selecting on (see below). When you run it, it will pop both (or more) *VALUE promptings. We have used this approach many time (labels being one of them...). I do know that WorldWriter allows more than 45 values on a VALUES selection and you do have to Page Down to get another screen once you fill the first screen.

(example in Data Selections screen)
Y Address Number . . . . . . . . . . . . . EQ *VALUE
And Y Address Number . . . . . . . . . . . . . EQ *VALUE
And Y Address Number . . . . . . . . . . . . . EQ *VALUE
And Y Cost Center. . . . . . . . . . . . . . . EQ *ALL
And Y Search Type. . . . . . . . . . . . . . . EQ E
And Y Employee Y/N . . . . . . . . . . . . . . EQ Y

World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)


Well Known Member
I don't think you'll get any records with this selection, because the
address number cannot equal one of 45 numbers AND also equal one of 45
different numbers.

Seems to me you'd have to change the AND / OR selection to OR, and once you
do that you have to repeat all the other selection criteria (cost centre,
search type, Employee Y/N) for each OR.


Jon Curry
Farmers Co-operative Dairy Limited (A7.3 cum 8)

Mailing Address:
P.O. Box 8118
Halifax, Nova Scotia, Canada B3K 5Y6

Physical Address:
745 Hammonds Plains Road
Bedford, Nova Scotia, Canada B4B 1A8

Phone: (902) 835-4005 Ext. 3155
Fax: (902) 835-1583
E-mail: jon.curry@farmersdairy.ns.ca


VIP Member
Re: RE: DreamWriter data selection question

Jon is correct, you would have to set up all the criteria each time with OR's between them. Sorry for the confusion, I was doing a quick example without thinking much...

World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)
I believe you are correct in that you can only have as many values as there is
on the "values screen." You are also correct in that the way around this is to
place the field in the data selection again with an or operand (be sure to
include any other data selection in this group as well). The user may be
confusing the DreamWriter with WorldWriter or AS/400 Query where you can do