• David Ziffer (10/13/2010)


    Unfortunately in this day & age we still don't have relational databases that allow us to divide our various objects into different name spaces, so this task is left to the developer. At some point we are potentially going to want to name one thing "table X" and another thing "view X", and the only difference in the names will be whatever we choose to designate something as being a "view" vs. "table". If we choose nothing to designate tables from views, then we have to start making arbitrary name choices in order to accomplish this, but the whole point of RAP is consistency, and its code generators never make arbitrary choices.

    If you have a relation (table) and a derived relation (view) of the same thing, your design is nonsense. So is a view and a table need their names distinguishing by |TBL and VW prefixes you need to wake up and fix the problem that you have represented the same thing twice instead of once.

    Tom