>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