Home > Archive > FoxPro database connector > October 2005 > Comparing DBF files - VFP 6??









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 Comparing DBF files - VFP 6??
Bill Cohagan

2005-10-27, 8:34 am

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-27, 8:34 am

AFIELDS()
ATAGINFO()
GenDBC.prg

-Anders

"Bill Cohagan" <cohagan@nospam.nospam> skrev i meddelandet
news:OfLkO5RzFHA.3660@TK2MSFTNGP15.phx.gbl...
> 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-27, 8:34 am

Is GenDBC available in VFP6?

Thanks,
Bill
"Anders" <anders@anders> wrote in message
news:ebCeUuSzFHA.3864@TK2MSFTNGP12.phx.gbl...
> AFIELDS()
> ATAGINFO()
> GenDBC.prg
>
> -Anders
>
> "Bill Cohagan" <cohagan@nospam.nospam> skrev i meddelandet
> news:OfLkO5RzFHA.3660@TK2MSFTNGP15.phx.gbl...
>
>



Olaf Doschke

2005-10-27, 8:34 am

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-27, 8:34 am

Also look at:

COPY STRUCTURE EXTENDED TO NewFile

- Rush

"Anders" <anders@anders> wrote in message
news:ebCeUuSzFHA.3864@TK2MSFTNGP12.phx.gbl...
> AFIELDS()
> ATAGINFO()
> GenDBC.prg
>
> -Anders
>
> "Bill Cohagan" <cohagan@nospam.nospam> skrev i meddelandet
> news:OfLkO5RzFHA.3660@TK2MSFTNGP15.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com