ASE Database forum - text + char

Author

text + char

teric

2005-09-14, 9:24 am

Hello,

Can anyone help me on how to concatinate a text field and a
char field together?

Thanks

Bret Halford

2005-09-15, 1:24 pm

ASE doesn't particularly support updating of TEXT or IMAGE values
on the server side (i.e. through TSQL commands);
the way you are expected to do it is to write a client program that can
read the text value into a buffer on the client machine and append
the char value (by using a function like the c function strcat() ), then

use WRITETEXT to store the updated TEXT value back into ASE.

Some sample code is available in
$SYBASE/OCS-12_5/sample/ctlibrary/getsend.c

Cheers,
-bret

teric wrote:

> Hello,
>
> Can anyone help me on how to concatinate a text field and a
> char field together?
>
> Thanks

teric

2005-09-23, 1:24 pm

Page is not available. Can you give me more link other than
this one. Thanks!

> ASE doesn't particularly support updating of TEXT or IMAGE
> values on the server side (i.e. through TSQL commands);
> the way you are expected to do it is to write a client
> program that can read the text value into a buffer on the
> client machine and append the char value (by using a
> function like the c function strcat() ), then
>
> use WRITETEXT to store the updated TEXT value back into
> ASE.
>
> Some sample code is available in
> $SYBASE/OCS-12_5/sample/ctlibrary/getsend.c
>
> Cheers,
> -bret
>
> teric wrote:
>
>

Jason L. Froebe [Team Sybase]

2005-09-23, 1:24 pm

teric wrote:
> Page is not available. Can you give me more link other than
> this one. Thanks!
[color=darkred]

at a unix prompt, type:
cd $SYBASE/$SYBASE_OCS/sample/ctlibrary

at a windows prompt:
cd %SYBASE%\%SYBASE_OCS
%\sample\ctlibrary

The getsend.c example program is there.

--
Jason L. Froebe

"There is usually a balance between the left and the right... checks &
balances... the bane of the government but the boon of the people" -
Jason L. Froebe

WebBlog http://jfroebe.livejournal.com

TeamSybase (http://www.teamsybase.com)
ISUG member (http://www.isug.com)
Chicago Sybase Tools User Group (http://www.cpbug.com)

Sponsored Links