Subject | Re: [ib-support] How to add to string constant? |
---|---|
Author | Helen Borrie |
Post date | 2002-11-21T05:28:53Z |
At 06:43 PM 20-11-02 +0200, you wrote:
You can use the UDF ascii_char from ib_udf.dll:
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
Then
insert into Table1 (Field1)
values ('String'||ascii_char(13)||ascii_char(10))
heLen
>Hello IB Support.Andrew,
>
>I need something like that:
>
>insert into Table1 (Field1)
>values ('String\n')
>
>I mean characters like ASCII 13 or ASCII 10. How to do that?.
You can use the UDF ascii_char from ib_udf.dll:
DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
Then
insert into Table1 (Field1)
values ('String'||ascii_char(13)||ascii_char(10))
heLen