>>Some of the time it would be hard to tell if I didn't get a "filtered view" result set, because it would be a small data set. But other times, it would be painfully obvious, like on a table with 50K or more records, because of the huge dropoff in speed. You can tell for sure if you do a DBF('myselectcursor') and it ends in ".DBF", not ".TMP".
>
>Are you sure about this, Fred? I've never seen a cursor with a DBF extension, and have been relying on USE AGAIN to determine if it's filtered or not. Probably you could look at the cursor with MODI STRU, also, and the base table properties would show up (just a guess, I can't ever seem to get a filtered result set when I want to, only when I don't want one) < s > I'm not sure if RECCOUNT() works, either...

Bruce,

I've always used this method for determining this. In fact, my routine for making a SQL-SELECT cursor r/w checks to make sure that the extension is ".TMP" or it returns an error. And you are correct, RECCOUNT() will return the # of records in the real .DBF file, not the cursor, if it's a filtered view. Just try a SELECT from the command window, and then do a DISPLAY STATUS. It's really very dependant on what clauses you put on the SELECT, though.