Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to use updateable views...
Message
From
08/11/1998 21:35:32
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00155397
Message ID:
00155618
Views:
31
PMFJI, perhaps I am overreacting to the quoted statement, but you do not have to set a field in a view in order to set THAT SAME field to updateable. But yes, as Nick said, you do have to have _a_ key field for the table that you are updating fields in. The reason, as it's been explained to me, is how does the view know which record to update if it doesn't know what its key field is.

HTH

p.s. my sympathies to for working on views AND a deadline :-)

...
>>>But I can't make the other fields updateable UNLESS I make them keyfields as well... Am I missing something here?
>>
>>You have fields from 2 tables in your view, so if you want to be able to update them all, you should set 2 key fields (tstParent.prntid and tstChild.prntid), then you can make any of view fields updatable, with the condition that "All Tables" in "Tables" combobox on "Update Criteria" tab is selected.
>
>Ok, this is definitely something I've got to get a handle on, but in the meantime, I've got a project to finish and I'm going to have to stick to what I know for now.
>
>Thanks for your help
>
>Larry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform