Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Get ASCII code of character
Thu, May 2 2019 9:49 AMPermanent Link

Yusuf Zorlu

MicrotronX

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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent Link

Yusuf Zorlu

MicrotronX

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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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
Image