Re: Field Names

["Buddy McClean" <Buddy.McClean@xxxxxxxxxxxx>]

Thanks, unfortunately I know zilch about SQL.  

> > > B Stone <bvstone@xxxxxxxxx> 6/7/2019 9:36 AM >>>
Dynamic SQL would probably be the best way.  Build the select statement
using the name of the field to select data from.


Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #10 <https://www.bvstools.com/mailtool.html>: Resend
Emails - When emails are sent using MAILTOOL Plus or another addon, those
emails are logged and you have the ability to resend them one by one, or as
a batch (ie, all unsent emails at once).

On Fri, Jun 7, 2019 at 9:33 AM Buddy McClean <Buddy.McClean@xxxxxxxxxxxx>
wrote:

> 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.