INSERT INTO... problems (Ammending text)
Date: 4 Mar 2003 10:01:58 -0800
Message-ID: <a6811d09.0303041001.e4eab36_at_posting.google.com>
I've submitted this issue to my support staff but have found this NG
to be quite helpful and the participants quite knowledgeable. I'm an
Implementation Specialist for a database application product for
Government use with OK sql skills. Pasted below is the message I've
sent to my support staff with which I would appreciate any
information.
Thanks in advance!
{paste}
SQL> select dkt_cd, dscr from dktcd where dkt_cd = 'DECRERC';
DKT_CD DSCR
SQL> select ext_txt from dktext where dkt_cd = 'DECRERC';
EXT_TXT
1 row selected.
In this extended text, we have 'NOW,' followed by three carriage
returns. When I put this query in SQL+, it actually returns as:
SQL> select ext_txt from dktext where dkt_cd = 'DECRERC';
EXT_TXT
The three bar's (#) each equal a carriage return.
Problem:
SQL> select ext_txt from dktext where dkt_cd = 'DECRERC';
EXT_TXT
I had a question regarding modifying existing rows in the extended
text for dockets. Let's look at DKTCD.DKT_CD = 'DECRERC'
---------- ------------------------------------------------------
DECRERC DECREE
This docket code has associated extended text:
NOW,
S/J:
NOW,###S/J:
1 row selected.
I need to have DKTCD.DSCR text inserted as the first line in
DKTEXT.EXT_TXT for a given DKT_CD. If this was done for the example
above (DECRERC) example, the following would be returned as extended
text:
DECREE#NOW,###S/J:
1 row selected.
This would basically take this description (DKTCD.DSCR = 'DECREE'), append it with a carriage return, and insert it at the beginning of DKTEXT.EXT_TXT. {/paste}
Thanks again! Received on Tue Mar 04 2003 - 19:01:58 CET