General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only