Hi,
I'm trying to create an updatable view. My base table has a compound primary key such as Field1 + Field2 + str(Field3,8,0) + Field4.
I can't quite figure out the syntax for the dbsetprop() command to set the key field. I've tried these commands with no luck. Any ideas?
dbsetprop('Field1 + Field2 + str(Field3,8,0) + Field4', 'Field', 'KeyField', .T.)
dbsetprop('Field1, Field2, str(Field3,8,0), Field4', 'Field', 'KeyField', .T.)