Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Name vs actual File Name
Message
From
22/09/2004 11:56:36
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00945027
Message ID:
00945041
Views:
21
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>By some UT member request I'm writing code and got stumped on some thought, which I'm a little bit lazy to create a test, so I hope that somebody can answer the question directly. The ADBOBJECS() function returns table names if used with "Table" parameter. What does it mean table names? Can the name of the table be different than the actual filename? I probably asked that question before but how can we find out the whole filename of the given table without opening it? Though if I want to use LUPDATE() I would need to open that table. Or is there a way to also get last modification date without opening a table?
>
>Thanks a lot in advance.

Yes tablename is a DBC property not actual file name.
open database testdata && Assuming you renamed customer to MyNiceCustomer
for ix=1 to ADBObjects(arrProp,"TABLE")
 if upper(DBGetProp(arrProp[m.ix],"TABLE","Path")) == "CUSTOMER.DBF"
    ? arrProp[m.ix], fullpath(DBGetProp(arrProp[m.ix],"TABLE","Path"))
 endif
endfor
If w/o opening table includes lowlevel then no.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform