Skip to Content.
Sympa Menu

freetds - [freetds] READTEXT problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ian Ashley <iashley AT picdar.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] READTEXT problem
  • Date: Wed, 06 Oct 2004 09:23:04 +0100

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





Archive powered by MHonArc 2.6.24.

Top of Page