>>>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')
>>? 'the caption is '+ DBGETPROP('testtable.field2','Field','Caption')
>>
>
>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')
>
>and error message is "cannot find object testable in database"
>
>Regards,
>Koen
Koen, bear in mind that in Portugal is earlier than in the Netherlands, so it's more "Sunday morning" to me than it is to you, therefore my state of consciousnesses is still waiting for a boost, or a coffee, whatever, but I'm not quite following what you're saying.
In your original code, you had
DBSETPROP('Testtable','Field','Caption','My Long Caption')
Since you're required to specify the field of the table for which you want to set a property, this code will raise an error. The code I posted corrected this, and will work unless, of course, there is no table named "Testtable" in the current database, or no field named "field2" in the "Testtable" table. But this was set in the previous two lines, wasn't it?
----------------------------------
António Tavares Lopes