What information of a dbf is stored in the dbc?

[Peter]

I want to know what other information are stored in dbc besides the ones that
can be listed by using List Database.

1. Does dbc contain something like record counter or table length for each
dbf?
2. Does using commands (something like DML in SQL) such as pack, delete,
insert, replace, reindex, append, recall on a dbf affect dbc?

Thanks.

[Stefan Wuebbe]

Post by Peter
I want to know what other information are stored in dbc besides the ones that
can be listed by using List Database.

Yes, but gendbc.prg (in the VFP Tools folder) lists the entire content
of a DBC (except that Stored Procedures are put separately in a
"KRT" file).

Post by Peter
1. Does dbc contain something like record counter or table length for each
dbf?

No.

Post by Peter
2. Does using commands (something like DML in SQL) such as pack, delete,
insert, replace, reindex, append, recall on a dbf affect dbc?

No.


hth
-Stefan

[Peter]

Hi Stefan,

Since dbc does not contain record counter or table length info, it will
mean that if I have 2 set of data which has the same structure but different
only in # of records in each table, I can exchange the dbc without any
problem.

What is the best way to implement data structure change for these 2 set of
data so the structure will always be identical?


Thanks.

Post by Stefan Wuebbe

Post by Peter
I want to know what other information are stored in dbc besides the ones that
can be listed by using List Database.

Yes, but gendbc.prg (in the VFP Tools folder) lists the entire content
of a DBC (except that Stored Procedures are put separately in a
"KRT" file).

Post by Peter
1. Does dbc contain something like record counter or table length for each
dbf?

No.

Post by Peter
2. Does using commands (something like DML in SQL) such as pack, delete,
insert, replace, reindex, append, recall on a dbf affect dbc?

No.
hth
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

[Dan Freeman]

The easiest way, by far, is to buy a copy of Stonefield Database Toolkit
which will do this for you.

(http://www.stonefield.com)

Dan

Post by Peter
Hi Stefan,
Since dbc does not contain record counter or table length info, it
will mean that if I have 2 set of data which has the same structure
but different only in # of records in each table, I can exchange the
dbc without any problem.
What is the best way to implement data structure change for these 2
set of data so the structure will always be identical?
Thanks.

Post by Stefan Wuebbe

Post by Peter
I want to know what other information are stored in dbc besides the
ones that can be listed by using List Database.

Yes, but gendbc.prg (in the VFP Tools folder) lists the entire
content of a DBC (except that Stored Procedures are put separately
in a "KRT" file).

Post by Peter
1. Does dbc contain something like record counter or table length
for each dbf?

No.

Post by Peter
2. Does using commands (something like DML in SQL) such as pack,
delete, insert, replace, reindex, append, recall on a dbf affect
dbc?

No.
hth
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

[Stefan Wuebbe]

Hi Peter,

Post by Peter
Hi Stefan,
Since dbc does not contain record counter or table length info, it will
mean that if I have 2 set of data which has the same structure but different
only in # of records in each table, I can exchange the dbc without any
problem.

Right. I do so often, for example after having modified only some
local view definitions of a DBC.

Post by Peter
What is the best way to implement data structure change for these 2 set of
data so the structure will always be identical?

I agree with Dan and do use Stonefield Database Toolkit for that
purpose, too. I believe creating an own tool might almost always be
more "expensive" than buying SDT, except you want to ship only a
few "Alter Table ..." lines occasionally.


hth
-Stefan