>>>>Hi, Jayesh
>>>>I have no problem with primary keys and I have clear understanding how they works. My problem is slightly different: if I have a view based on above tables, can I actually add records to it? To be more precise, how SQL updates works when you need to add new records to a view? Will it create new records in all files?
>>>>Please, give me some advice...
>>>>Thanks
>>>>Leo
>>>
>>>Please forward me any context regarding this problem.
>>>
>>>But I believe that complex views can't be used for adding or editing.
>>>If yes, please clear my confussion.
>>>Thanks
>>>Aashish
>>
>>Only one table can be updated from a view.
>
>Thanks to all of u but i use cursor to update my tables at lots of places and at other places direct tables.
>
>Im using views only for reporting.
>
>Only one table can be updated from a view. I agree
just because you directed this reply to my box, I can answer that this is not right: you can update several (at least it works for two) tables. Also, it's useless to use views for reporting. Here, it's enough to use cursors.
Edward Pikman
Independent Consultant