>>DIMENSION loanguarantors(1) >>loanguarantors(1)=" " >> >><pre> >>SELECT name FROM mainbase!v_client WHERE clienttype<>"B" INTO ARRAY Indiv >>Display memory >>>>
>>SELECT name FROM mainbase!v_client WITH (BUFFERING = .t.) WHERE clienttype<>"B" INTO ARRAY Indiv >>Display memory >>>Because without the buffering clause, VFP SQL will take records from disk, and you seem to have row buffering on the view - so the last record added is still in the buffer but not on disk (if you had table buffering, none of them would be until you explicitly tableupdate() the buffered records).