![Confused :?](./images/smilies/icon_confused.gif)
Error during lookup
Moderators: chulett, rschirm, roy
Yup, exactly.
And rather than use the 'SQL Builder tool' to create your source queries, I much prefer the 'Generate SELECT clause from column list; enter other clauses' way of doing things. I wouldn't touch the Builder with a thirty-nine and a half foot pole. That long 'Generate' option is what used to be called simply 'Column Generated' in the earlier versions.
Save the user-defined or custom sql for those times when you have absolutely no other choice.
![Wink :wink:](./images/smilies/icon_wink.gif)
And rather than use the 'SQL Builder tool' to create your source queries, I much prefer the 'Generate SELECT clause from column list; enter other clauses' way of doing things. I wouldn't touch the Builder with a thirty-nine and a half foot pole. That long 'Generate' option is what used to be called simply 'Column Generated' in the earlier versions.
Save the user-defined or custom sql for those times when you have absolutely no other choice.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers