Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
All, I have created a query with Query Manager that concatenates a number of character fields to one field. Each field concatenated field is seperated with a semi-colon. Thus: Fielda CONCAT ':' CONCAT Fieldb CONCAT ';' CONCAT FieldC .... etc. The last character is a semi-colon and there is no STRIPping. I run this query over one file and the output is directed to a file. This file is send afterwards to the PC with FTP. So far no problems. The only problem is: The query adds two extra bytes at the beginning of the records in the file. I assume this indicates the actual length of the field, as query interprets it as a variable length character field. My question is: How can I output such a query without receiving the binary value in front of each record? TIA, With regards, Carel Teijgeler
This mailing list archive is Copyright 1997-2026 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.