Hi Bernardo,

For these properties You must set 0. cursor before calling SQLEXEC()

CURSORSETPROP( 'FetchSize', 30,0) 
CURSORSETPROP( 'FetchAsNeeded', .T.,0)

MartinJ

>Srgey,
>
>you hit the nail right on the head,
>I thoght that the propertys has to be set after the cursor not before. gess I was wrong.
>
>
>Thanks.
>
>
>>See CURSORSETPROP() Function and check SPT cursor fetching and progress displaying for SPT cursor downloading FAQ #8150.
>>
>>>AS you all know when you are creating a View you have some options like
>>>
>><snip>
>>
>>>is there a way to have this options set for a cursor created mith the SQLEXEC() command.
>>>
>>>
>>>I need the
>>>DBSetProp('EXCHGTAB', 'View', 'FetchSize', 30) &
>>>DBSetProp('EXCHGTAB', 'View', 'FetchAsNeeded', .T.)
>>>
>>>for a number of cursors.
>>>