As some of you may remember, I had a project recently where I needed Blanks to show up in Excel file output - where normally numerical data is displayed. The suggestion was to use NULL values. So - I implemented that - and it worked great! That folks here that use the system were very happy with that results.
Problem is - they didn't look closely at the resulting output. You see, they need to look at an Excel file output to confirm the data looks correct. But, then they need to generate this Text file output - which gets sent to clients. Those Txt files are then imported into their systems. And, needless to say - the format of the Text files must stay consistent and MUST be properly formatted.
So - imagine my surprise to learn that the Text files were wrong. Turns out - they are Missing a Blank character for the field that was set to accept NULL values. And, this morning - I reviewed as much of the online documentation in VFP (release 9) - and could find NO References to this type of problem.
Have other experienced this before? Do I merely need to add an additional digit (currently its 17,2 - and I'm looking to make it 18,2) to resolve this problem? Does this make sense???
Thanks in advance to all the ProFoxers!
Kurt Wendt Senior Systems Analyst [GlobeTax_SecondaryLogo_TwoColor_Lo]https://www.globetax.com/ One New York Plaza - 34th Floor New York, NY 10004-1936, USA Tel. +1-212-747-9100 Direct +1-212-405-8246 www.GlobeTax.comhttps://www.globetax.com/
GlobeTax does not provide or offer, and this is not, tax, investment or legal advice. This email and any attachments hereto is intended only for use by the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, please immediately notify the sender at +1-212-747-9100 and permanently delete the original and any copies of this email.
--- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png ---