Re: Query/400: How do you create a numeric field with specific characteristics?

Hi Al,

Let query 1  once create a second(dummy) file  with  the original empno field.

Link this dummy file in query 2  unmatched with primary
and use the field from the dummy file.

Best,

Lucas

At 08:07 PM 11/09/2002 -0400, you wrote:

Hi Mapics ML:

I am trying to write a new Query (let's call it Query # 2)
that takes data from an input DB file and outputs the
result by adding records to an existing output DB file.
(The existing DB file was created by Query # 1.)

One of the fields from the output DB File is a "numeric"
field with the following characteristics:

Name: EMPNO
Text: EMPLOYEE NUMBER
Len: 5
Dec: 0

Using Define Result Fields, how do I create a "numeric"
field in Query # 2 that has the same characteristics as
shown above?  (The DB input file used for Query # 2 does
not have a EMPNO field so I assume that Define Results
Field is the only way to create this field using
Query/400.)

If you need any additional information, please let me know
through the Mapics ML.

I look forward to your suggestions and comments.

Al Gershen
Grants Pass, OR
aldg1@charter.net
http://www.AlsPhotographs.com
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

www.viva-lancia.com
Best Regards,
                Lucas

If you can't convince them, confuse them.(Confucius)

L. Geheniau                                     M.I.S. supervisor /
Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@bladel.tokheim.com
        l.geheniau@chello.nl
sms: No phone!  0615026840