Skip to Content.
Sympa Menu

freetds - RE: [freetds] READTEXT problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] READTEXT problem
  • Date: Wed, 6 Oct 2004 10:21:31 +0200

>
> I am trying to use the READTEXT command to some text from a
> table however I
> am failing at the first hurdle. The following SQL is required
>
> DECLARE @ptrval VARBINARY(16)
> SELECT @ptrval = TEXTPTR(P_LONGTEXT) FROM P_SIMPLE WHERE P__URN = 1
> ...
>
> When I execute this in isql or in code (I am using unixODBC)
> the second line
> reports that the variable @ptrval isnĀ¹t defined. Does anyone have any
> suggestions?
>
> Thanks in advance,
> Ian
>

You have to put the command in a single line like

DECLARE @ptrval VARBINARY(16) SELECT @ptrval = TEXTPTR(P_LONGTEXT) FROM
P_SIMPLE WHERE P__URN = 1

variables are destroyed at end of statement or batch...

freddy77



  • [freetds] READTEXT problem, Ian Ashley, 10/06/2004
    • <Possible follow-up(s)>
    • RE: [freetds] READTEXT problem, ZIGLIO, Frediano, VF-IT, 10/06/2004

Archive powered by MHonArc 2.6.24.

Top of Page