See
SPT cursor fetching and progress displaying for SPT cursor downloading FAQ #8150
>
>I have a sqldatabase with tables that are containing a large amount of information. Via my vfp7 program i manage this data. Now i have the following problem:
>
>i want to query the big tables without downloading the hole result, yes i want to activat 'FetchAsNeeded'. The problem is that i don't have any views in my dbc and i want to keep it like this. In other words i work via sqlpassthrough.
>
>I know i can activate fetching on a view via cursorsetprop('FetchAsNeeded',cTableAlias) but like a say i don't have any table or view in my container.
>
>Is it possible to activate fetching on whatever sqlresult i get using sqlpassthrough. Can i tell to my connectionhandle that i want to fetch for ex by 100 records ?
>
>
--sb--