Hi Dennis,

I can't tell you anything about CAs 'cause we haven't switched our apps to that approach. However as Craig and Victor wrote, we use either parameterized RVs or SQLs with several WHERE clauses to reduze the amount of data that has to be retrieved. However, there always exists the posibility that a user really wants all the records or a bunch of several thousands and thats where FetchAsNeeded and FetchSize come into play. But as I already wrote...those routines were written a long time ago and haven't yet transformed to CA use.


>Thomas,
>
>

>	liRecords = 200
>	liStatus = 0
>	lcCursor = SYS( 2015 )
>	lcSqlSelect = [select * from mytable]
>	CURSORSETPROP( [FetchAsNeeded] , .T. , 0 )
>	IF liRecords > 0
>		CURSORSETPROP( [FetchSize] , 200 , 0 )
>	ENDIF 
>	DO WHILE ! USED( lcCursor ) AND liStatus >= 0 
>		liStatus = SQLEXEC( giConnectIDAsync, lcSqlSelect , lcCursor )
>	ENDDO
>	CURSORSETPROP( [FetchAsNeeded] , .F. , 0 )
>

>
>In your code, you used SQLEXEC(). Does this mean CursorFill() does not work hand in hand with the Fetch* properties?
>
>Thanks
>Dennis