I want to insert data into a table having two fields

column_name data_type
abc char
pqr datetime

the value that has to go into this text type field is a string which has line feeds in between.
for eg
abc should be inserted with 'id1'
par should be inserted with 'This is a
description about
id1'

ie it should have line feed inbetween

wat should be the query?

zeta

Hi zeta,

try this:
execute procedure ifx_allow_newline('t');
INSERT INTO table_name (abc, par) VALUES ('id1', 'This is a
description about
id1');

(assuming that the second column is defined as par char(..), not as "pqr datetime" ...)

Hope this helps
ifx