Humm... I see. As I mentioned to Cetin, I haven't used the nofilter clause. Does this mean that if I am trying to select a record set, and the number of resulting records has to be accurate (used for a counter, total, etc.), that means I have to include a NOFILTER clause every time, just to be sure, correct?

If the NOFILTER clause is not supported by other DB's, that then means that I would have to have a conditional add of the NOFILTER clause, depending on the back-end, right?

- Brian


>If WHERE clause of select statement is optimazable and only fields from the table is requested, foxpro opens FROM table with AGAIN clause and ALIAS . If subset of the fields is requested than SET FIELDS command used to show only those fields. ? DBF() will return original table name in this case. There's NOFILTER clause that forces foxpro to create cursor as temporary table.
>

VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)


www.wulfsden.com