This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Say we have a presentation-purposes view v_complex which consists of 3 tables, only one of which is to be updated. View select a.id, a.parentkey, a.field1 a.field2,a.field3, b1.labelforfield1, b2.labelfor_field2, c.field1,c.field2, c.field3 from tableA a left outer join Lookups b1 on a.field1=b1.lookup_value left outer join Lookups b2 on a.field2=b2.lookup_value join ParentTable pr on a.parent_key = pr.id It can be seen that there is a parent-child 1:N association involved. We are not doing anything with the parent, though. This view only needs to update/insert a.field1, a.field2, a.field3 I want to show the user the view because it has helpful labels and values if interest from the parent, etc, but I only want to update/insert on table A. My 'RadGrid' is bound to the view, not the underlying table. I can definitely tell the grid which columns are labels and which ones are really updateable ( and hidden normally). Is there some way to do this? Example? |
|