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.
>>>