10. Or an alternative to views where tables can be defined with virtual fields which point to functions. So for example I can say: SELECT balance, name FROM customers WHERE balance < 0; ...where balance actually performs a behind the scenes JOIN against a transactions table and totals the customers credits and debits. I realize views can do this but for adding a single dynamic field they are cumbersome and correct me if I'm wrong but I don't think you can UPDATE against a view.You are wrong, you can make updatable views.
Yes you can but not out of the box. You have to write some rules to make this go, isn't it ?
Aly. -- Aly S.P Dharshi aly.dharshi@xxxxxxxxx "A good speech is like a good dress that's short enough to be interesting and long enough to cover the subject"
