Re: sybase - manupalating value in field which is of TEXT datatype


<bret@xxxxxxxxxx> wrote in message
news:1168443961.531809.139600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

sharad.salun...@xxxxxxxxx wrote:
hi,

I want to manupalate and again update the string of field which is of
TEXT datatype in sybase.

i thought of using writetext function. but writetext function replaces
whole string with new string. instead i want to change certain string
value from field.

thank you.
Regds . .sharad m s

Nonetheless, using writetext is the way to do it. ASE doesn't support
much more than storing and retrieving TEXT values. To update part of a
text value, read it into a buffer in your client application, make the
changes, then write it back to ASE using WRITETEXT.

-bret


Or, if your text value isn't too big, you can convert the text column into a
varchar (16384) local variable, convert the variable back to text, and then
use writetext. (I assume that you are on a reasonably recent ASE version
such as, say, 12.5.0.3 or later. Basically, this just saves you some
client - SQL data transfers.)


.