General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>A previous message in this thread (from Yuri Rubinov) and a little more playing indicates that Nofilter dictates if the original delete state is maintained in the query results.
>
>The SQL in Create View must default to Nofilter...
That's correct, Todd, but the real thing is that without NOFILTER you are NOT getting a real result set, but rather a filtering of the real table itself.
There are several anomolies with this (and why I say VFP should never have done this):
1) RECCOUNT() on the (alleged) result set cursor will return the total record count in the original table;
2) You can USE IN < original-table > to close it, but if you then immediately execute USE < original-table > EXCLUSIVE you will get the "table already open" error even though you just USEd it to close it.
3) What you've been seeing.
There are others that don't come to mind right now.
All in all, they were a bad idea. Look at the trouble it caused you!
cheers
>
>Todd
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