Hi Steve.

Also on top of what Caroline sent, you will have to make sure that you have SET DATA to the database you want the dbgetprop for. It only works with the currently selected database.

HTH

Dan

>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