>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