General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks Hector,
Unfortunately, I can't do this because the table could well be held within a SQL Server Database, which means I cannot select * from the table. So I'm stuck with Selecting * from the view.
Not to worry,
I just create a cursor and scan round the record set dumping a copy of required records into the temporary cursor from the view.
It's a shame the select approach doesn't return the uncommitted records as doing something like SELECT DISTINCT is a lot easier than coding it!
Cheers, Mark
Previous
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