>
>So to avoid any confusing I will repost and if you or others have lust to review, but coffee first please, teach me how to make use of dbgetprop() to find the caption of any field.
>

>CLOSE DATABASES all
>ERASE test*.*
>CREATE DATABASE test
>CREATE TABLE testtable (field1 c(10), field2 c(10))
>DBSETPROP('Testtable','Field','Caption','My Long Caption')
>? 'the caption is '+ DBGETPROP('testtable.field2','Field','Caption')
>

>
>Regards,
>Koen

Sorry to hear about your surgery, hoping the best for you.

Now, you have to indicate the field when you are referring to a field property, that is: DBSETPROP('Testtable.field2','Field','Caption','My Long Caption').

You got it right when you GET the property, in line 4, it is just a matter of setting it right also when you SET, in line 3 (puns intended).