× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Ted, I think you have to include the orignal fields you wish to CONCAT or 
SST in the logical as well.
Try adding C3AKCD, C3ALCD, C3AMCD and ACALCD to the logical.

>Can someone help me out?  Is my syntax correct or is this impossible?
> 
>ACAKCD, ACALCD and ACAMCD all exist, the rest I'm trying to create in 
>this logical file.
> 
>0022.00 A            C3SAPN             I      CONCAT(C3AKCD C3ALCD 
>C3AMCD) 
>0023.00 A                                      COLHDG('Assessors 
>Parcel' 'Numbe
>0024.00 A                                      TEXT('Assessors Parcel 
>Number') 
>0025.00 A            C3AKCD             I      SST(ACAKCD 1 3)  
>0026.00 A            C3ALCD             I      SST(ACALCD 1 3)  
>0027.00 A            C3AMCD             I      SST(ACAMCD 1 3)  
>0028.00 A          K C3SAPN 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Troy Bryant 
Analyst Programmer
Patrick Autocare.
Phone: +61 03 9926 9913
Fax: +61 03 9926 9977
Mobile: +61 0408 397 333
T.Bryant@xxxxxxxxxxxxxx


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.