Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Unanswered: Insert data into a field of datatype text

    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

  2. #2
    Join Date
    Feb 2005
    Posts
    33

    allow newline

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •