Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing empty logical values, but not when .F.
Message
 
 
To
26/08/2008 15:57:12
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01341974
Message ID:
01341976
Views:
11
This message has been marked as the solution to the initial question of the thread.
>Ok, this is sort of strange, but I need to replace values in a field only when they are truly empty. If the value is .T. or .F., then I want to leave it alone and not replace it. Sounds weird, but this is an import to a table from an excel spreadsheet and the values will either be .F. or empty. I need to change all the empty ones to .T., but not affect the ones that already have a .F. in them.

Use ISBLANK() function for your test.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform