Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Paths
Message
From
29/10/1997 21:12:25
 
 
To
29/10/1997 13:49:49
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00057214
Message ID:
00057315
Views:
39
>>>>Is there a way to get the table paths from the DATABASE (DBC)
>>>>I tryed to use the ADBOBJECTS with tables but this only returns
>>>>the name with out the path. When I used the DBC I saw a memo field
>>>>that conntained the path and table name in it. I was hoping for
>>>>a simple VFP function that I have missed.
>>>>
>>>>Charles
>>>
>>>Select table1
>>>? dbf()
>>
>>I should have explained better. I am building a version control
>>for one of my apps and I try to come up with some solutions to problems.
>>If the DATABASE is missing I FREE the tables recreate the database and add
>>the tables back into it. The problem is this:
>> Create a database
>> Add several tables
>> Then delete one table (could happen)
>> : Now if you try and readd it to the database
>> : it says table name already used
>> : Try and drop or delete the table from the database
>> : and it says it can't find the table.
>> The only solution I have found it to create a temp table with
>> the same name free then drop the table from the database. But to
>> create it so the database can drop it I need it in the same path
>> as the original.
>>
>>
>>Charles
>
>Ok, try
>? dbgetprop("tableX","table","path")

Thanks this is what I was looking for.

Charles
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Reply
Map
View

Click here to load this message in the networking platform