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