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. Regards 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'? Thanks -- Glenn Thompson Senior Analyst American Trouser, Inc. gthompson@xxxxxxxxxxxxxxxxxxxx -- 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 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