Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question: How to get Table Name? Filename different
Message
From
31/03/2004 12:30:36
Donald Lowrey
Data Technology Corporation
Las Vegas, Nevada, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Question: How to get Table Name? Filename different
Miscellaneous
Thread ID:
00891219
Message ID:
00891219
Views:
68
Good morning all

I may be brain dead this morning.

A contained table has a filename of xyegf.dbf. However, the table name is mytable.
The table is opened with "USE xyegf IN 0 ALIAS myalias"
The problem arises as the bit of code is looping and thru each pass of the loop the alias is always "myalias". No other tables are open.

This fails, because the file name is not in the dbc.
DBGETPROP("xyegf","table", "primarykey")

This works
DBGETPROP("mytable","table", "primarykey")

DBF() does not help, because it returns the file name.

So what I need help with, is a way to return the table name.

Thanks in advance for your help.

Don Lowrey
Next
Reply
Map
View

Click here to load this message in the networking platform