Here is what I have.....
SELE V_ANNDEMO **this is an remotve view to an sql table
sCATTER MEMVAR BLANK MEMO TO laBlank
m.visdate = ttod(v_anndemo.visdate)
m.formdate = ttod(v_anndemo.formdate)
m.xferdate = ttod(v_anndemo.xferdate)
m.date_ent = ttod(v_anndemo.date_ent)
m.date_val = ttod(v_anndemo.date_val)
FOR i = 1 TO FCOUNT()
lcFldName = FIELD(i)
luFldVal = EVAL(lcFldName)
REPLACE ALL (lcFldName) WITH laBlank[i] FOR ISNULL(EVAL(lcFldName))
ENDFOR
insert into v_old_anndemo ** this a remotve view into a 2.6 table
=tableupdate(.t.,.t.)
but the tableupdate fails ( it is capture with aerrors) and tells me that that still some fields with null values.....
Thanks in Advance.
J. Turner