General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Question: How to get Table Name? Filename different
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only