>>Hi,
>>
>>I have troubles with DBGETPROP function to get the caption:
>>
>>

>>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')
>>

>>
>>errors "command contains unrecognized phrase / keyword" on row 4
>>
>>What is possibly going on here?
>>
>>Regards,
>>Koen
>
>Slow Sunday morning, is it?
>
>For the error you're reporting, you're just missing a tick to start the "the caption is " string.
>
>But, for what you're intending to do, an error will pop up in the row (ahem, line...) 3. When you're referring to a field property, you must fully specify the field, otherwise VFP won't have a clue on your intentions, as you did - correctly - in the GET function.
>
>

>CREATE DATABASE test
>CREATE TABLE testtable (field1 c(10), field2 c(10))
>DBSETPROP('Testtable.field2','Field','Caption','My Long Caption')  && didn't specify the field, 
>? 'the caption is '+ DBGETPROP('testtable.field2','Field','Caption')   && properly formed string
>

Antonio,
Yes this is a sundamonring error on error!!!
However quickly corrected and added the forgotten tick
still you clam I did not specify the field however

DBSETPROP('Testtable.field2','Field','Caption','My Long Caption')  && field = field2 

and error message is "cannot find object testable in database"

Regards,
Koen