>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
When you create a table, it's not automatically added to the currently open database. You have to use the Add Table command. At least that's how I think it is, I have never used VFP databases myself.