Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Mike,
>
>>WOW! OK, that's cool, but you didn't make the join expressions exactly match the index expressions. Made me wonder if there's any harm in doing so. It works fine.
>>
>
>As far as I know it is not necessary to modify WHERE clause because UDF arguments in a WHERE are always passed by value.
It may not be necessary, but if there is a simple rule like where clause should exactly match index expression it's easier to build apps. Remembering the intricate details of what is necessary in this case versus that case is the definition of steep learning curve.
>
>>Doesn't that exclude passing an array by reference to the UDF?
>>
>
>Yes, but that's the behavior that WHERE has, parameters are not passed by ref (see my answer above). So, if key expression passes parameter by ref, it doesn't match an expression in WHERE.
>
>Thanks,
>Aleksey.
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