>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!
local lnI, lcWhere
scatter memvar blank
for lnI = 1 to fcount()
lcWhere = field(lnI) + " IS NULL"
replace field(lnI) with evaluate("m." + field(m.lnI)) for &lcWhere
next
If it's not broken, fix it until it is.
My Blog