Discussion:
Comparing DBF files - VFP 6??
(too old to reply)
Bill Cohagan
2005-10-09 22:12:50 UTC
Permalink
I've got two versions of a DBF file and I'd like to compare the two to
identify what has changed (in the schema) between the two versions. Is
there a better way to do this than viewing through the pinhole of the
database designer window? Is it possible to print some representation of the
schema?

Thanks in advance,
Bill
Anders
2005-10-10 07:50:44 UTC
Permalink
AFIELDS()
ATAGINFO()
GenDBC.prg

-Anders
Post by Bill Cohagan
I've got two versions of a DBF file and I'd like to compare the two to
identify what has changed (in the schema) between the two versions. Is
there a better way to do this than viewing through the pinhole of the
database designer window? Is it possible to print some representation of
the schema?
Thanks in advance,
Bill
Bill Cohagan
2005-10-10 11:36:15 UTC
Permalink
Is GenDBC available in VFP6?

Thanks,
Bill
Post by Anders
AFIELDS()
ATAGINFO()
GenDBC.prg
-Anders
Post by Bill Cohagan
I've got two versions of a DBF file and I'd like to compare the two to
identify what has changed (in the schema) between the two versions. Is
there a better way to do this than viewing through the pinhole of the
database designer window? Is it possible to print some representation of
the schema?
Thanks in advance,
Bill
Olaf Doschke
2005-10-10 12:52:12 UTC
Permalink
Hi Bill,

There always have been samples provided with VFP.
In the Visual Studio days I think these are "hidden" in a separate
MSDN installation. That installation should give you a directory

...\Microsoft Visual Studio\MSDN98\98Vsa\1033\Samples\VFP98\

There you should find a tools subdir.

And another command would be COPY STRUCTURE or
COPY STRUCTURE EXTENDED. That combined with
ATAGINFO() should answer all structural questions you may
have on a table.

Bye, Olaf
Rush Strong
2005-10-13 14:35:29 UTC
Permalink
Also look at:

COPY STRUCTURE EXTENDED TO NewFile

- Rush
Post by Anders
AFIELDS()
ATAGINFO()
GenDBC.prg
-Anders
Post by Bill Cohagan
I've got two versions of a DBF file and I'd like to compare the two to
identify what has changed (in the schema) between the two versions. Is
there a better way to do this than viewing through the pinhole of the
database designer window? Is it possible to print some representation of
the schema?
Thanks in advance,
Bill
Loading...