Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert records in a view
Message
 
To
26/07/1996 13:01:10
Marcelo Daniel
Martin Cubero S.A. de C.V.
Cuautla Mor., Mexico
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00004613
Message ID:
00004648
Views:
49
>What happend with the Key fields, when you try to insert a new record in a view. Of course that you have to give them the right value, but it seems like they're not updatable, and they don't have to when they all ready have a value, but when they'er just added?

Key fields for remote views are, by default, not updatable.

>
>Do I have to insert the new record directly in the relaying table?
>

Well, if you feel like programming in direct =SQLEXEC() mode... =)

>Do I have to change the key fields update settings in order to put the right values in the key fields, and if so can I do this dinamicaly?

Yes. Use the view designer, under the "Update Criteria" Tab.
The only way I know of doing this dynamically programmatically is by creating two views, one with updatable key fields and
the other, without. Then switching between the two.
alistair israel
Distressed DBA, Sleepy SysAd, Weary WebMaster (aka Senior Software Engineer)
aisrael@poboxes.com
Makati City, Philippines
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform