Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keylist property
Message
From
16/11/1999 09:31:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Keylist property
Miscellaneous
Thread ID:
00291446
Message ID:
00291446
Views:
55
I've created a view on a TAP customer file. It contains a zero-filled customer number c(5) and other fields. I've joined in a master file that has a similar key, where the name, address, etc. is stored. The fields for the TAP customer are all updatable, but the files from the master file are not updatable. When I add new records to the TAP file or change the values the TAP customer file updates correctly. When I delete a TAP customer file, I get the following error message:

Error 1492: No key columns are specified for the update table "mastcus". Use the KeyFieldList property of the cursor.

Is VFP trying to delete the Master record?

Any Ideas?

TIA
Mike
Mike
Next
Reply
Map
View

Click here to load this message in the networking platform