Database Views and Speed of Retrieval
Quote:
>I would be interested to know about anybody's experiences with database
>views and what problems they had (if any).
One big problem is if your program is standalone and client server. If you
locally join tables with the same field name, it makes the field names
field_a and field_b. In a remote view, it makes the names field and field1.
You can't change this in the designer, so you have to create the views
manually (which is a pain).
From the standpoint of saving information in a view that's been modified, it
makes real sense to use the view. In one command you've update the
information in your database. But they can be a pain to set up under certain
circumstances.
Rob