FoxPro Alias Table Name

Posted on 2013-10-28
Last Modified: 2013-10-29
Hello Experts!

How can I shorten the name of a table?
For Example:

FROM Long_Table_Name LTN;

In SQL you can just put a space and then LTN for the short name, how do you do this in FoxPro?

Question by:smithmrk
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 42

Accepted Solution

pcelba earned 500 total points
ID: 39606621
Yes, this works for FoxPro same way as on SQL Server.

In addition to this you may open any table with a short alias directly

USE d:\path\Long_Table_Name ALIAS LTN

One more hint: Don't use M as short alias because it collides with  M.  memory variable prefixes.

Author Closing Comment

ID: 39606722
LVL 29

Expert Comment

by:Olaf Doschke
ID: 39606872
Besides USE ALIAS you can also use alias namesin SQL, as you initially wrote, with or without AS keyword:

SELECT LTN.fieldx, ATN.fieldy;
FROM Long_Table_Name LTN ;
LEFT JOIN Another_Table_Name AS ATN;

Open in new window

Besides M you should also aviod a-j as those are reserved for workarea 1 to 10 for historical reasons (backward compatibility with 2.x versions, if not even older).

Bye, Olaf.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 39606911
Thanks for the additional information Olaf!

LVL 29

Expert Comment

by:Olaf Doschke
ID: 39606950
You're welcome.

Another hint: If you're having problem with a query length, especially the WHERE clause: take a look at SYS(3055)

Bye, Olaf.
LVL 42

Expert Comment

ID: 39607058
Just to clarify:  Local (short) aliases a - j can be used in SQL commands without restrictions. The local alias has precedence to any other language element and historical reasons cannot apply here.  Alias m can also be used in SQL commands but then you cannot distinguish between table (aliased as m) column and memory variable of the same name.

FoxPro has no reserved keywords and you may use language elements as variable and column names almost freely (with some restrictions and surprises, of course)... Variables a - j do not cause any problems.

SYS(3055) can be useful but I did not use it yet - my SQL commands are too short probably. But to overview the list of available FoxPro functions is geed practice. :-)

Author Comment

ID: 39608611
WOW, Thanks for all the Information!
I really appreciate the knowledge you folks have as I try to be a better programmer!

Thanks again for all your help in the past, now, and defiently in the future!


Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Alternative to "Do While" 12 168
How VFP9 apps runs under Windows 8 64 bits? 6 553
MS Access no longer ablle to link to FoxPro tables 30 370
VFP 7 or VFP 9 Image/Detail Band Resize 9 118
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question