MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

RE: Field Type 'P' in a query



fixed

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.





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

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