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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

alias

Status
Not open for further replies.

nguyen12

Technical User
Sep 30, 2001
42
US
I have a question about alias. How does it work? I created an alias for the table in my program, but when i call the alias name, i got the message alias name does not exist. Thank you.
 
Hi

USE myTable IN 0 ALIAS myAlias

in the above, myTable is opened IN a work area which is available as free work area (not known to us specificaly) and we call that work area as myAlias.

So when you say.. SELECT myAlias.. this workarea gets selected and the access is defaulted to the myTable used in that alias area.

Hope this helps you :)
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top