Tim,

I don't know of a way to make SPT work with fetch as needed. One option is to create views on the fly. You can create a temp .dbc and create the views in code. Another option would be to set your connection for asynchronous use and just start the SQLEXEC() then display the grid while it fetched the rest of the records. You'd get the whole table whether the user scrolled the grid or not, but at least you could show the grid while fetching the rest of the records.

>Thanks...
>
>I thought I saw a tools somewhere ...
>But it has genview it it wasn't exactly what I wanted.
>
>Yes I do do this this way....
>But I want to use the fetch as needed...
>
>SQLEXEC(h,'select * from intcolor')
>cursorsetprop("fetchasneeded",.t.)
>
>I.E.
>When I have a grid it automatically fetches the next few records as I scroll down..
>
>However Problems being...
>1)I need to set this property only on some tables....
>2)I need to make the cursor first then set this property...
> By then it's too late I already downloaded the whole table...
>
>Any suggestions...