Hi all,

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 ?


Thnx