Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need syntax help on dbsetprop() KeyField
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00153752
Message ID:
00154191
Views:
19
>>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.
>
>You don't have a single key field, but several. Therefore, judging from the documention, you should do
>
>dbsetprop(Field1, "Field", "KeyField", .T.)
>dbsetprop(Field2, "Field", "KeyField", .T.)
>dbsetprop(Field3, "Field", "KeyField", .T.)

I don't think specifying more that one key is allowed. The expression specified should be specified as the key expression in the tables definition (I believe).
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform