Ooops. Never mind, then. :I

>Tamar is talking about use of the FORCE keyword on the SQL SELECT command., not FORCE the xBase programming language.
>
>
>>A friend of mine used to use FORCE. I seem to remember that it was a C/C++ library for writing executables and dlls using VFP databases. He seemed to think it was fast, but maybe it doesn't use Rushmore properly, (or at all). It is possible that it depends more on its internal C++ routines to optimize queries. Of course, I think that would be a mistake, but then I didn't write FORCE. His apps that he created with it did seem quick.
>>
>>Dana
>>
>>>Has anyone ever found a situation where FORCE was helpful in a query? I've been experimenting and so far haven't found any real benefits. In fact, in some cases, it seems to eliminate optimization of a filter and actually slow the query down.
>>>
>>>Anyone got real examples?
>>>
>>>Thanks,
>>>Tamar