>Hi,
> Is it possible to set FecthAsNeed and FecthSize for Local View?
>
>Thank you

You can using DBSetProp() [see DBGetProp in VFP help for the parameters]. While this does primarily apply to remote views, the following all returned TRUE. However, when I open the view, all records are still retrieved all at once:

create sql view test as select * from lineitem
? dbsetprop('test', 'view', 'fetchasneeded', .t.)
? dbsetprop('test', 'view', 'fetchsize', 100)
use test   && retrieved all records
close tables all
? dbsetprop('test', 'view', 'maxrecords', 500)
use test   && retrieved all records again