Source language: Translate to:

CreateView Command Questions

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

CreateView Command Questions

Postby Pat Baner » Mon May 02, 2011 12:37 pm

Looking for a little experience here. What is the pupose of Create View command when the table is already open? I know that it: "Creates an alternate, virtual view of a table", but why would I use it?

Also, what are some uses that this command is good for (situations that directly interfacing with the source table doesn't solve or allow)?

thanks
Pat Baner
 
Posts: 75
Joined: Tue Jan 04, 2011 9:21 am

Postby cp4w » Mon May 02, 2011 2:47 pm

a typical use would be as follows.

Customer Table
- idnbr
- firstname
- lastname
- age

Customer Activity Table
- idnbr
- itembougt
- amountpaid


so instead of duplicating the customer information in each table you have it once and create a view joining the 2 base tables.
cp4w
 
Posts: 533
Joined: Sun Apr 03, 2005 4:37 pm
Location: Great Neck, NY


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest