Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 14 of 14 total |
Fixing Phone numbers in SQL with a computed field |
Mon, Jul 27 2015 4:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< 'm sure you've said that before somewhere but I'd obviously forgotten. Would it be possible to enhance COMPUTED to use simple scripts. >> No. That would require re-engineering the entire way that computed/generated columns work, which seems rather silly when you can just change the word 'COMPUTED" to "GENERATED" and get what you want. Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 29 2015 2:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< 'm sure you've said that before somewhere but I'd obviously forgotten. Would it be possible to enhance COMPUTED to use simple scripts. >> > >No. That would require re-engineering the entire way that computed/generated columns work OK >which seems rather silly when you can just change the word 'COMPUTED" to "GENERATED" and get what you want. Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data. Roy Lambert |
Wed, Jul 29 2015 6:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data. >> Yes, but after thinking about this further - a script would have the same issues with identifier resolution that a function reference would have. The bottom line is that you can't evaluate database-wide operations during a client-side operation. There's just a bunch of inaccessible information that is only server-side. Tim Young Elevate Software www.elevatesoft.com |
Thu, Jul 30 2015 3:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data. >> > >Yes, but after thinking about this further - a script would have the same issues with identifier resolution that a function reference would have. The bottom line is that you can't evaluate database-wide operations during a client-side operation. There's just a bunch of inaccessible information that is only server-side. Yes but only if the script contained things like SELECT or CALL. Unless you go to the effort of creating a second programming system for COMPUTED columns I can see it would be difficult to check these sort of things and have to rely on the sanity of the programmer. Shame but I understand an accept the restrictions I can think of some ways of doing it that would almost certainly bomb at some point - just in case you'd like those sort of suggestions Roy |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |