At 03:03 AM 11/03/2003 +0000, you wrote:

>Hello,
>
>I am working out some external table samples for a project.
>Is it possible to generate a "NEWLINE" character in ISQL?
>Could a query like
> 'INSERT INTo EXT_TBL VALUES ('NAME','LAST','20030310', <NewLine> )'
>be created?
>I have tried some trivial things like 'char(13)+char(10)', '\n' , a
>smallint field with 1013 inside... Is there a way of doing this?

Clément,

Apart from pasting the characters directly into a UI and storing them in a
lookup table, the only way I know of is to use the ascii_char UDF from
ib_udf.dll - the corrected version by Claudio Valderrrama, distributed with
Firebird:

DECLARE EXTERNAL FUNCTION ascii_char
INTEGER
RETURNS CSTRING(1) FREE_IT
ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';
commit;

then

INSERT INTo EXT_TBL (column_list_please!)
VALUES ('NAME','LAST','20030310', ascii_char(13) || ascii_char(10) )

heLen