Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting the Blank back into empty numeric fields
Message
 
 
To
13/03/2007 18:43:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01203203
Message ID:
01203204
Views:
13
>I'm finishing a project that has "converted" fp 2.5 for DOS to VFP 9. One of the programs opens a table and copies it to a text file (type SDF). In 2.5 blank numerics were created with the replace command and copied to the text file as blanks. In VFP the numerics are, well numeric with a zero value which is then copied to the file. They want to see blanks again. I could open the text file and stuff the values but have been looking for a way to get VFP to either leave the blank numerics empty and/or copy them as blanks.
>
>Any ideas?
>
>
>thanks, jeff

Use BLANK command.

UPDATE. Disregard, didn't read your requirements carefully. For text files you would have to convert them using any of the available text manipulation commands as you planned.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform