Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting alias to the database and not including the table

Status
Not open for further replies.

paulcudd

Programmer
Mar 4, 2002
7
GB
i'm not sure how CR uses the 'alias' method. I dont mean to be pedantic but a database is a collection of tables and not an individual table and this may be part of the problem of how i'm trying to use the Alias method

When I try to set the alias from Database\Set Alias it encapsulates the table, eg C:\Pdoxwin\Private\invoices.db is equal to the alias PRIV.
I want the alias to point only to the database,
eg C:\Pdoxwin\Private.
If at later date I move all my 300 tables i simply change the alias's path, that is one alias amended.
C:\Newlocation\Pdoxwin\Private
As it stands now I am giving an alias to every table. If I move my 300 tables I would be required to amend every alias.
eg PRIV = C:\Newlocation\Pdoxwin\Private\invoices.db

Your help to a new CR'er will be much appreciated.
PC

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top