>I am able to connect and send sql statements through, with no worries. What I am having trouble with is, I want to limit the number of rows returned with a sql statement, and then get more of the sql result when I needed it. I thought the fetch sql statement in maxdb may of been able to let me do this, but I am not sure how to go about it.

Darren:

In that case, read the VFP help file for:
FetchAsNeeded
DbSetProp
DbGetPropCursorSetProp

Also to limit the numbers of records you can say TOP n (I assume it would work in Maxdb which I don't have).

HTH