Hello
I have a question about views.
Since views are updateable, I wanted to know a few things about views.
I have a
Orders table
nOrderNo
cCustomer
I have a
OrderDetails table
nOrderNo
cItem
nQty
I have a updateable view with the sql like this ..
Select Orders.*,OrderDetails.* from Orders Left Join OrderDetails on Orders.nOrderNo = OrderDetails.nOrderNo
Now if I append a record to this view what all is happening internally ?
I need some very good documentation on views.
Any sugestions ?
Thanx in advance .
Regards
Hiten K M
( The best and the worst are yet to come .. keep coding ! )
My Resume >>