>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


Maybe there is an EZr way but you could do

= ADBOBJECTS(la_table,'table')
FOR EACH lc_table IN la_table
   IF FULLPATH(DBGETPROP(lc_table,"Table","Path")) = DBF()
      ? lc_table
      EXIT
   ENDIF
ENDFOR