Documenting Tables

[JulieWulie]

Is there an easy way to extract table definitions in VFP5 to a word document or something similar?

Thanks in anticipation!

Jules

 

[Mike Gagnon]

Jules

It depends what you mean by "table definitions".

Have you tried :

select mytable 
COPY STRUCTURE EXTENDED TO c:\test
USE c:\test
BROWSE

This would guve you the field names, the field type etc...

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[JulieWulie]

Thanks very much. That's pointed me in the right direction!

 

[rgbean]

Also check out the Documentation Wizard and a number of apps in the downloads area of the UT (

http://www.universalthread.com/).

Rick

 

[Stella740pl]

You can also try the old way:

LIST STRUCTURE TO FILE MyFile.txt

It still works in VFP (although you can achieve more attractive results using other methods).

 

[Mike Lewis]

JUles,

There is a documentation utility on Compuserve called DBC2WRD.EXE. It produces a nice Word document containing all the details held for all tables in a DBC.

If you are a Compuserve member, go to the MSDEVAPPS forum and search the library for the filename. If not, try this link:

http://forums.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps

Mikke

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[mspratt]

Jules,

You may find the output of GENDBC and GENDBCX to be of interest. It is an easy way to backup the structure of your DBC and makes copying it (structure only, no data) a snap.

Regards,

Mike

 

[JulieWulie]

Thank you everyone for your help!

Mike, this sounds like just what I need but unfortunately I'm unable to join up from where I am to be able to download the file.

 

[Mike Gagnon]

Jules

Here is another option

http://winnersoft.coolfreepages.com/vfp/gstables.htm

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[JulieWulie]

Mike

That is absolutely fab! Thank you very much. My job is done!

Jules