|
Dynamic SQL would probably be the best way. Build the select statement using the name of the field to select data from.B Stone <bvstone@xxxxxxxxx> 6/7/2019 9:36 AM >>>
Good Day,
Perhaps a silly question and an obvious answer, but I seem to have a
bit of fog about it.
What is the best way to translate a field that contains the name of
another field to be able to reference the second field. Other than do
a bunch of compares.
DCL-S Field1 char(8) INZ('FIELD2')
To be able to use FIELD2 in calculations. FIELD2 is an actual field in
a record, but I only have the literal name of the field.
As an Amazon Associate we earn from qualifying purchases.
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.