Greetings!

(Using VFP8 SP1)

I don't know about everyone else, but I've been using Gendbc.prg for years. I'm one of those old "Foxes" who needs to see it printed out (hence, my nickname, the "Desert Fox"). I print the output created by gendbc (it's a source code file, i.e., a *.prg file) whenever I get to a point where either my head is spinning, which is more often lately, or as a reference when I come back to a project I have not worked on for awhile.

Going through this process, I noticed two things:
1) When generating the *.prg file, all VIEW SQL properties are truncated to the length set by SET MEMOWIDTH TO. I fixed that by executing this is my config.fpw file:
COMMAND = SET MEMOWIDTH TO 2048 (nice round number).
This now provides the complete SQL code in the generated *.prg file. YEAH! But, that's only HALF of the battle...read on!

2) When I print the source code output from the Gendbc execution, the SQL for each view is truncated. My guess is that it's truncated at about 256 characters or so. I have not been able to overcome this problem and I see nothing on any of the "usual places" about this.

Anyone have any suggestions, ideas, thoughts or questions about this, please let me know. I have some very long and some complicated views that I need to print out and VFP8 is not handling this very well.

Thanks and have a HAPPY THANKSGIVING!