Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tom Crain
  Where is Tom Crain?
 Saint Paul
 Minnesota - United States
 Tom Crain
 To: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Yousfi Benameur
Subject: RE: File Path of Alias
Thread ID: 268846 Message ID: 268956 # Views: 31 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 4:07:12 PM         

> > Is there a function to retrieve the file location (pathname) if only a file alias is known? I only have the file alias via a function available in a "host" program. This function opens the application's data files. I need to determine the path to these files. I don't want to search for files via the File() or fullpath() functions. The only thing I can think of is to use a Display Structure command, then parse the file path name out of that text file. Ugly. Any suggestions would be greatly appreciated.
> DBF() :Returns the name of a table open in a specified work area or a table name from a table alias...
> DBF([cTableAlias | nWorkArea])
> CREATE CURSOR ycurs (myfield C(10))
> messagebox("cursor location :"+DBF()+chr(13)+"File(dbf())...."+iif(file(dbf()),".t",".f."))

> Regards
> Yousfi Benameur

DBF()! Many thanks, Yousfi.


File Path of Alias Posted by Tom Crain @ 7/15/2010 1:45:15 AM
RE: File Path of Alias Posted by Yousfi Benameur @ 7/15/2010 3:13:11 AM
RE: File Path of Alias Posted by Tom Crain @ 7/15/2010 4:07:12 PM