>>Hello!
>>I am trying to write values from my array into five fields in a database
>>so I have
>>
>>

>>DIMENSION loanguarantors(1)
>>loanguarantors(1)=" "
>>
>><pre>
>>SELECT name FROM mainbase!v_client  WHERE clienttype<>"B" INTO ARRAY Indiv
>>Display memory
>>

>>
>>So why doesnt my last value show it self.
>>like if i add PEter...its only going to show if i add susan and susan will only show in memory if i add felix and so on
>
>Try
>
>>

>>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).
>
>For the opposite - what the thread title says - append from array, the array needs to be two-dimensional.

it does the same thing:(