ASCII values?

[mike777]

Does anyone know how to return the ASCII character for a numeric value? Example: I provide 65, the application returns "A".
Thank you.
-Mike Kemp

 

[Oppenhiemer]

Not sure if there is a generic method using Interbase. Think perhaps you should look at creating a UDF and calling this from Interbase.

Opp.

 

[mike777]

Thanks, Opp.
I suppose, then, you'd have to do a series of If statements like:

Create procedure ASCIIVals(InStr varchar(1)) returns (RetVal integer) as
begin
if InStr="a" then
     RetVal=97;
if InStr="b" then
     RetVal=98;
if InStr="c" then
     RetVal=99;
etc.

Does this sound correct?
Thanks.
-Mike

 

[Oppenhiemer]

Yes Mike, but you wont be able to do this using VBA. UDF's need to be compiled into a DLL to be used by Interbase. Check out this article :

http://community.borland.com/article/0,1410,27134,00.html

Im sure there are free UDF's around - and may be worth checking those out (one may give you the functionality you need.) Hope this helps..

Opp.

 

[MartijnTonies]

There's an UDF that comes with IB:

Returns the ASCII value of the character passed in.
DECLARE EXTERNAL FUNCTION ASCII_VAL
CHAR(1)
RETURNS INTEGER BY VALUE
ENTRY_POINT 'IB_UDF_ascii_val' MODULE_NAME 'ib_udf';




Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com