Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Still - I don't see the need of the optimizing behavior vfp shows.
>
>I'd agree with that, except that if VFP optimized UDFs, there would be a ton of complaints where someone's UDF was misbehaving and they'd blame VFP and call it buggy.
I am not following you: If I CREATE a UDF based index und use it via seek/scan the result it gets used instantly, if the index expression is "seen" in a join, a temporary index is created on the same expression and the UDF momentarily loaded. If the UDF is the same, the result will be the same as if the information in the cdx is reused. There also is the re-evaluation of each clause after a rushmored query to make sure no false records are loaded. And anybody stupid enough to load a different UDF regularly will certainly be bold enough to sound off about a buggy VFP <bg>.
regards
thomas
Previous
Next
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