>I need to return the caption of a field in a database. However, I need to do this on the fly at runtime. Given variables for the database and table name.
>My table name and database will be changing.
>
>I have tried:
>? dbgetprop(dbc()+'.'+field(1,alias()),"Field","Caption")
>
>but this returns a data type mismatch error.
>
>The field() function returns a numberic because my first field value is a number.
>
>The dbc() function returns a datatype of undefined U
>
>I've experimented with macro substitution and evaluate() but have had no luck.
>
>I think what is happening is it is returning the character string and then immediately evaluating it as a variable.
>Thanks

This seems to work

lcField=Alias()+"."+Field(1, Alias())
?lcField
?DBGetProp(lcField,"FIELD","Caption")