I have a table deliberately created with null values in numeric fields. This allows browsing the table and seeing zero value fields as blank rather than zero.. i want to print the table and expected to use the HTML generator on the file menu but it turns out that the nulls mess up the formatting of the output.
Is there away to have the html generator treat the nulls as blanks? Another non null way to browse a table without zeros in empty numeric fields?
Thanks in advance, joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Have you tried the SET NULLDISPLAY TO " " setting?
I think, that this "Generate HTML" menuoption uses the _GENHTML program, thus you could change the generation to your expectations.
Then there's the "WebPublishing Wizard" (under Tools / Wizards), you'll find the sourcecode in VFP9\Tools\xsource\VFPSource\Wizards\wzweb That one is coming with more "fancy" styles (from the 2000 aera), but maybe it works better with NULLs.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Joe Yoder Gesendet: Dienstag, 27. September 2022 19:34 An: profoxtech@leafe.com Betreff: Nulls and generated HTML
I have a table deliberately created with null values in numeric fields. This allows browsing the table and seeing zero value fields as blank rather than zero.. i want to print the table and expected to use the HTML generator on the file menu but it turns out that the nulls mess up the formatting of the output.
Is there away to have the html generator treat the nulls as blanks? Another non null way to browse a table without zeros in empty numeric fields?
Thanks in advance, joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]