Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Warning Reports
Message
 
To
07/03/2000 23:53:00
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00343130
Message ID:
00343131
Views:
26
>Hi, all
>
>I have a view with a composite key, when i do tableupdate to update de database visual fox tell me,
>
>WARNING: The key field defined by the key field property for 'myTable' is not unique.
>
>I defined that key field is not unique, what's the way for VFP don't show this warning.
>
>
>Thank's in Advance
>
>Joao Batista

Joao, if your key field is not unique tehn VFP cannot properly identify the record to update.
The purpose of the key field is to be unique. If you need that field which you are using as a key now for other purposes
you should add another key field which is truly unique and used only to identify the records (it is called the surrogate key)


Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform