Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Computed Columns |
Wed, Mar 12 2008 7:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Are computed columns limited to "simple" SQL? What I'd like to do is put code in to produce a formatted column based on the data in 1 (or possibly 2) other columns in a table. Ultimately the objective is to replicate Trim(FormatMaskText(FormatMask + ';0', Numbers)) + ' ' + Alphas; With FormatMask being selected depending on the first few characters of the input field. I can then store a field (its phone numbers) without any spaces and display nicely formatted on screen/paper. Roy Lambert |
Wed, Mar 12 2008 3:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Are computed columns limited to "simple" SQL? What I'd like to do is put code in to produce a formatted column based on the data in 1 (or possibly 2) other columns in a table. >> They can refer to any built-in functions and any columns within the same table. Currently they cannot use UDFs, due to client-side restrictions for remote sessions. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |