Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Get ASCII code of character |
Thu, May 2 2019 9:49 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | i.e.
SELECT ASCII( SUBSTRING(MYFIELD,1,1) ) FROM MYTABLE should result in 65 if myfield starts with 'A' We need such a functionality in scripts to create calculations and checks for IBAN and SWIFT-Codes within SQL. Any possibility to get this as internal edb function? Yusuf Zorlu MicrotronX |
Mon, May 6 2019 11:27 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Yusuf,
<< SELECT ASCII( SUBSTRING(MYFIELD,1,1) ) FROM MYTABLE should result in 65 if myfield starts with 'A' >> I'll see what I can do. In the meantime, you should consider implementing any custom functions that you need as an external module in Delphi. Tim Young Elevate Software www.elevatesoft.com |
Fri, Sep 13 2019 8:36 AM | Permanent Link |
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi | Tim Young [Elevate Software] wrote:
<< I'll see what I can do. In the meantime, you should consider implementing any custom functions that you need as an external module in Delphi. Any news here? -- Yusuf Zorlu MicrotronX |
Sat, Sep 14 2019 3:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Yusuf
I think what Tim was suggesting was that its not high on his list, it might appear in the next build but he won't be doing a custom build to provide it. Why not implement your own function. Its simple enough CREATE FUNCTION "ASCII" (IN "InStr" VARCHAR COLLATE AFK_CI) RETURNS INTEGER BEGIN RETURN 64+POS(UPPER(SUBSTR(InStr,1,1)),'ABCDEFGHIJKLMNOPQRSTUVWXYZ'); END VERSION 1.00 Roy Lambert |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |