>>>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') >>>>>>
>>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 >>>
>DBSETPROP('Testtable.field2','Field','Caption','My Long Caption') && field = field2 >>and error message is "cannot find object testable in database"
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?