• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1545
  • Last Modified:

FoxPro Alias Table Name

Hello Experts!

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

SELECT *;
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?

Thanks,
Mark
0
smithmrk
Asked:
smithmrk
  • 3
  • 2
  • 2
1 Solution
 
pcelbaCommented:
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
SELECT * FROM LTN

One more hint: Don't use M as short alias because it collides with  M.  memory variable prefixes.
0
 
smithmrkAuthor Commented:
Thanks!
0
 
Olaf DoschkeSoftware DeveloperCommented:
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;
ON LTN.id = ATN.LTNid

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.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
smithmrkAuthor Commented:
Thanks for the additional information Olaf!

Mark
0
 
Olaf DoschkeSoftware DeveloperCommented:
You're welcome.

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

http://msdn.microsoft.com/en-us/library/43cab295(v=vs.80).aspx

Bye, Olaf.
0
 
pcelbaCommented:
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. :-)
0
 
smithmrkAuthor Commented:
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!

Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now