Hi!

Yes, you can use SPT. However, after opening the view, you cannot re-use the connection created by that view to run also SPT commands, because you will get error "Connection is busy" - connection is used by the fetching process.

Remote views could be created on the fly. You can create temporary database. Create a connection in it. Then create a remote view. All 3 have appropriate commands (CREATE DATABASE, CREATE CONNECTION and CREATE SQL VIEW with REMOTE option). All could be hidden for user and database files could be places in the TEMP folder.



>Hi Vlad,
>
>>You can split records to parts and download them as segments.
>
>>You can create the remote view - they have (!) a FetchAsNeeded property that is exactly what you're asking for.
>
>* Can I still use SPT for the rest of my app (everything else - actually my app is a small SQL browser/inspector utility - is ok with the exception of the Browse function)?
>
>* Can that (the remote view) be done programatically (as I could see I'll have to create a DataBase in order to implement the view) and used thru a normal VFP Browse statement ?
>
>Thanks!
>
>Fernando