Manish <manish.minni.m@[EMAIL PROTECTED]
> wrote:
> Hi
>
> I have two tables with text columns. I wish to update text column in
> existing rows in TABLE1 using data present in the text column of a
> corresponding row in TABLE2.
> (The row in TABLE2 can be selected without referring to the text
> column values)
>
> Sybase ver is 12.5.3
>
> BTW, I have read some of writetext & readtext in the manual, but it
> seems very complex, and if I have to use it, can someone give me a
> small example.
You can use a normal update statement.
I tried :
(22) create table t(i int, t text)
(23) create table s(i int, t text)
(24) insert t values (1, 'abc')
(25) insert s values (1, 'efg')
(26) update t set t.t = s.t from t, s where t.i = s.i
(27) select * from t
Don't forget to set textsize if datalength of the textfield
is larger dan 32768.
Luc.
|
