![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Fri, Sep 23 2011 8:35 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | We'll be able to do things like
COALESCE(IF(_fkSandT_Turnover='?',NULL,(SELECT _Turnover FROM SandT WHERE _Band = _fkSandT_Turnover)), IF(_fkSandT_Staffing='?',NULL,(SELECT 'Staff: '+_Staff FROM SandT WHERE _Band = _fkSandT_Staffing))) in computed columns? Roy Lambert |
Fri, Sep 23 2011 3:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< We'll be able to do things like ..... in computed columns? >> Never - computed columns are handled client-side, and therefore are unable to resolve anything outside of the scope of the current table's columns. Therefore, things like sub-queries and UDFs are out. Is there any reason why you can't use a generated column instead ? -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Sep 24 2011 3:28 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
>Never - computed columns are handled client-side, and therefore are unable >to resolve anything outside of the scope of the current table's columns. >Therefore, things like sub-queries and UDFs are out. Now you say that I remember. My personalised storage system is obviously due for replacement. >Is there any reason why you can't use a generated column instead ? Only my hatred of wasting space. Roy Lambert |
Mon, Oct 3 2011 9:08 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Only my hatred of wasting space. >> Just remember that the only space being wasted is disk space - computed columns still use the same amount of memory as generated columns, and incur additional CPU overhead. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |