Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Could the LIST SQL Keyword create lists of Integers as well as VARCHARs? |
Thu, Jun 28 2018 12:03 PM | Permanent Link |
Adam Brett Orixa Systems | I have a good number of Integer fields in my databases, which users want to see in lists.
I can write this: SELECT LIST(CAST(<IntegerField> as VARCHAR)) as FMIDs FROM <MyTable> .... but SELECT LIST(<IntegerField>) as FMIDs FROM <MyTable> would be easier. It is a tiny change I know. |
Fri, Jun 29 2018 2:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
If your suggestion was to automagically convert all datatypes to VARCHAR I'd support it. After all LIST is "simply" creating a VARCHAR with specified separators. Different datatypes would, I suspect, be a nightmare for Tim and for us as well. Roy Lambert |
Fri, Jun 29 2018 12:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< would be easier. >> Yeah, I certainly get that, but I'm not sure about starting to introduce features that perform implicit type conversions when the rest of the SQL is very much statically-typed. If the expression was producing an array of integers or something that was logically related to the input type, then I would say sure, but integers into a string, hmmm..... Tim Young Elevate Software www.elevatesoft.com |
Sat, Jun 30 2018 2:11 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>If the expression was producing an array of integers or something that was logically related to the input type, then I would say sure, but integers into a string, hmmm..... Oh goody - you're adding array column types into ElevateDB Roy |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |