>Thanks for the reply, Larry
>
>It must open another occurance of the view as this is a remote view accessing tables held within a SQL Server 7.0 database, so VFP doesn't have access to the base tables directly.
>
>Not to worry,
>
>I simply create a cursor and scan round my view dumping the required records into the temporary cursor.
>
>It's a shame the SQL SELECT doesn't return the uncommitted records as doing something like SELECT DISTINCT is a lot easier than having to 'hand code' it!
>
>Cheers, Mark
Hi Mark,
No VFP does not open the view again because that would entail making another trip to the remote server (which isn't done). It does internally what Hector posted you should try externally. It uses the disk presence (the temporary file created when you opened the view) and opens that again in another workarea under a new alias. It then queries that version for you.
Glad to see you found another way. :-)
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao