Re: How do I update (append) to a text column? (fwd)
On Tue, 14 Oct 1997, Peter Wages wrote:
> No Jonathan. Batch_Typ_Cd_Desc is not a blob field but a character field
> char(200). I'm afaid I misunderstood.
No problem; it is easily done (trust me -- I've misunderstood many
questions in my time!) I think that updating a char field can be
done in a single statement:
DATABASE logged;BEGIN WORK;
CREATE TABLE batch_type_codes
(
batch_type_code CHAR(2) NOT NULL,
batch_typ_cd_desc CHAR(40) NOT NULL
);
INSERT INTO Batch_Type_Codes VALUES('#A', 'Promissory Note (Stafford/PLUS)');
SELECT batch_typ_cd_desc
FROM batch_type_codes
WHERE batch_type_code = "#A";
UPDATE Batch_Type_Codes
SET (Batch_Typ_Cd_Desc) = (TRIM(Batch_Typ_Cd_Desc) || " Test")
WHERE Batch_Type_Code = "#A";
SELECT batch_typ_cd_desc
FROM batch_type_codes
WHERE batch_type_code = "#A";
ROLLBACK WORK;
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>