|
Home > Archive > FoxPro database connector > April 2005 > What information of a dbf is stored in the dbc?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What information of a dbf is stored in the dbc?
|
|
|
| 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 2005-04-07, 8:05 pm |
|
"Peter" <Peter@discussions.microsoft.com> schrieb im Newsbeitrag
news:43AFC726-841E-4C03-B94F- 7C8F63610940@microso
ft.com...
>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).
> 1. Does dbc contain something like record counter or table length for each
> dbf?
No.
> 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
-----------------------------------------------------------
| |
|
| 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.
"Stefan Wuebbe" wrote:
>
> "Peter" <Peter@discussions.microsoft.com> schrieb im Newsbeitrag
> news:43AFC726-841E-4C03-B94F- 7C8F63610940@microso
ft.com...
>
> 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).
>
>
> No.
>
>
> 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 2005-04-07, 8:05 pm |
| 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
Peter wrote:[color=darkred
]
> 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.
>
>
>
> "Stefan Wuebbe" wrote:
>
| |
| Stefan Wuebbe 2005-04-07, 8:05 pm |
| Hi Peter,
"Peter" <Peter@discussions.microsoft.com> schrieb im Newsbeitrag
news:5DA58E6C-8DC5-4ED1-BE42- 50C1C0767B5A@microso
ft.com...
> 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.
> 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
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------
|
|
|
|
|