Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Name vs actual File Name
Message
 
 
To
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:
00945095
Views:
20
>>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

Hi Cetin,

How can I obtain the information about record count without opening a table? How reliable this info would be?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform