Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing Null values in a table or in an array
Message
From
19/08/2009 20:06:41
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01419106
Message ID:
01419130
Views:
70
>Is there a quick way to replace all the fields in a record that have a .Null. value to a blank value of the field's type, i.e. " " for char, 0 for numbr, .F. for logical, etc.? If it is easier to do this in an array, please let me know.
>Thanks!

How about something like.......
SCATTER TO aValues MEMO
FOR iValue = 1 TO ALEN(aValues)
    IF ISNULL(aValues[iValue])
        BLANK FIELDS (FIELD(iValue))
    ENDIF
ENDFOR
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform