I'm hacking ISC4 file and run into some problem:

If I have external file:

CREATE TABLE log_table
EXTERNAL FILE 'C:\Program Files\Borland\InterBase\isc4.log'
( tstamp CHAR(20),
spc CHAR(1) DEFAULT ' ',
uname CHAR(31),
crlf CHAR(2) );

How can I insert the CR+LF into crlf field?

I tried like this:
INSERT INTO log_table (TSTAMP, UNAME,crlf)
VALUES ( CURRENT_TIMESTAMP, :un,'\r\n');

but the ISC4 was not accessible afterward. When I removed this 'crlf' column everything worked ok.

Riho-Rene Ellermaa
senior programmer
Hansabank