This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Why from such simple expression:
LightSpeed generate such strange SQL statement:
Wouldn't it be much compact and simpler:
|
|
|
Yep, it does look a bit verbose however it appears we have structured the translation of these binary predicates in this way for compatibility across all the supported providers. I will make a note to do a sanity check for 5 though as we have removed a few of the older providers so we may not need to be doing this anymore.
|
|