List stru to print

[jspellman]

First just let me say that I have been reading the tips listed for a few months now. I find that the tips and questions are great. I hope this one is not too trivial.

I have used Visual foxpro since VFP6. I also use dBase 4. I have found that the list strucure command is not formatted for printers in VFP6,&7. It is readable but difficult.

Is there a way to create a customizable display/list structure command?


Thanks,

John

 

[cslawtom]

You could base on the follow and write a program to do so.

use xxxxx
gnFieldcount = AFIELDS(gaMyArray) && Create array
CLEAR
FOR nCount = 1 TO gnFieldcount
? gaMyArray(nCount,1),gaMyArray(nCount,2),gaMyArray(nCount,3),gaMyArray(nCount,4)
* gaMyArray(nCount,1) is the field name
* gaMyArray(nCount,2) is the field type
* gaMyArray(nCount,3) is the field length
* gaMyArray(nCount,4) is decimal point
ENDFOR

 

[JackTheC]

Another, simple, method is this:

use xxxx
set printer font "Arial",7
list stru to print

Now the text fits on one line

 

[ramani]

HI
Look in

http://www.leafe.com/dl.html

and download GerryWhite.zip
That contains a utility (freeware),PrtStruc.prg for this purpose.

ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[ramani]

HI
Also look in

http://www.universalthread.com/wconnect/wc.dll?FournierTransformation~

There is a utility LS320.ZIP which you can download to avoid the word wraps.

ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

John,
As you can see, while LIST STRUCT was left in VFP for backward compatibility, most everone agrees that there are simply better ways to get the information for non-free tables.

Rick