>
>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).
----------------------------------
António Tavares Lopes