Table path in DBC

[Nro]

Hi.
My question is quite simple, but I can’t find any information on that.

I have one customer table (call it c:\test\cust001.dbf) and one address table (c:\test\cust002.dbf). The two tables are referenced in my INVOICE.DBC as custMain and custAddr respectively. I want, by reading the .DBC only, to find the real name and full path of each table for the alias custMain and custAddr.

VFP 9.0 SP2

Thanks in advance

Nro

 

[Mike Lewis]

Nro,

This is quite easy. The information you need is contained in the Properties field for each of the tables within the DBC. You need to open the DBC as a table, browse it, locate the rows for the tables in question (by looking at ObjectName and ObjectType), then open the Properties memo field and look for the file names and paths.

Actually, it's slightly more difficult that than, as the relevant names will be embedded in a bunch of binary data, but it should be fairly obvious when you do it.

For an example, including a screen shot, see my article, "Fixing broken backlinks in DBC and DBF files", at

http://www.ml-consult.co.uk/foxst-47.htm

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[Nro]

Hello Mike

Thanks again for the quick answer.
In my previous message, I forget to tell that I tried this

DBGETPROP("custMain","TABLE")

the third parameter was missing...

DBGETPROP("custMain","TABLE","PATH")

Now it’s OK, it's giving me the name of the table.

Thanks again.

Nro

 

[Mike Lewis]

Nro,

Yes, that's a much better method. I had been thinking about broken backlinks when I read your post, which is why I suggested looking into the DBC.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business