I've been thinking more about this, and I don't think there's more than one advantage there,
> Backends can be changed, Yup, the backend can be changed fairly (perhaps completely) transparently to the application. > fields can be added, No more or less than with a table, surely. Worse, if I'm trying to take fields *away* from tables, that'll break the views defined on them, which doesn't happen without the view. You might claim that this only happens in a badly designed data scenario, though I would have to point out that situations evolve and require redesign. > data normalized ??? Isn't this what data design is for? And if you mean that tables can be joined and made to appear as one table, I'd say *that's* what I'm complaining about. When I do anything other than view data the *appearance* falls apart leaving more to do than in the first place. Is that appearance particularly helpful? Though it p'raps doesn't sound like it, I'm trying to rant constructively. I see the separation is potentially useful, I'm just starting to get the feeling that the table is in fact naked though it thinks it's clothed. I'll have a deeper look at the CursorAdaptors since I'm (now) using VFP9. The fact that I'm using CodeBook is probably a bad and good thing. After the initial unpicking, it'll be easier to implement any change system-wide. Anywhere I can find Andy Kramek's stuff? You, Michael, & Steve have all talked about implementing something better via SQL, the VFP views are really SQL, so it looks like it's "just" a not-very-good implementation issue? D'you think something clever here will extend the Fox's life? 8-) Regards Mark Stanton One small step for mankind... _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
