Have you tried running a query over the file you wish to add records to,
select all of the fields and output to a file. Don't actually run the query
but print a copy of the query definition and it'll contain the correct field
descriptions you need.


Steve Dodkins 

Welcome ... to the world of air technology and drive engineering, the world
of ebm-papst. Get informed on our unique range of products. And get to know
how motor technology and engineering, aerodynamics and electronics are made
to interact to perfection in our innovative system solutions.

-----Original Message-----
From: Glenn Thompson [mailto:gthompson@xxxxxxxxxxxxxxxxxxxx]
Sent: 27 October 2004 20:51
To: Midrange Systems Technical Discussion
Subject: Field Type 'P' in a query

I'm trying to use query to add records to a file.  I keep getting a 
mismatched field type.

The file I want the records loaded into has a field type 'P'.  This is a 
COMP field.  How can I define a field in a query as a type 'P'?


Glenn Thompson
Senior Analyst
American Trouser, Inc.

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This thread ...

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