Unified SQL Function

[FredS]

OK playing around with this I tried a very simple:

"Select {fn CHAR(id)}, id from Client"

this should return 1 and 11, but
the built in Data Editor shows EmptyStr and garbage.. so does a data grid.

ID is an Integer field in a Firebird 2.5 Db

[ViktorV]

As it is stated in the SQL function paragraph of the Unified SQL section in UniDAC help: http://www.devart.com/unidac/docs/unisql.htm the CHAR function returns a character corresponding to the digital value of the passed argument. The character matching the code 11 is unreadable, so you see the empty string.

[FredS]

Got it, the function to use is 'TOCHAR'..

thanks

[ViktorV]

Thank you for your interest to our product. Feel free to contact us if you have any further questions.