>Have you tried to use COUNT using the same FOR clause the user issues?
>
>Kinda like if u use SCAN FOR , use COUNT FOR TO
In FOR condition is not optimized, this process may take a long time, that's why I don't want to do a count first...

If it's not broken, fix it until it is.


My Blog