Text Problem

[ucasesoftware]

In my stored procedure :

@resume text =null,

in my Code :

..Add("@resume", SqlDbType.Text, 2147483647).Value = myReader("resume")

but when i try to UPDATE, i have this error message :
Only text pointers are allowed in work tables, never text, ntext, or
image columns. The query processor produced a query plan that required
a text, ntext, or image column in a work table.


But i have no problem with INSERT

any idea ?

 

[Ken Tucker [MVP]]

Hi,

Maybe try

..Add("@resume", SqlDbType.Text, 2147483647).Value =
myReader("resume").tostring

Ken

 

[Larry Lard]

In my stored procedure :

@resume text =null,

in my Code :

.Add("@resume", SqlDbType.Text, 2147483647).Value = myReader("resume")

but when i try to UPDATE, i have this error message :
Only text pointers are allowed in work tables, never text, ntext, or
image columns. The query processor produced a query plan that required
a text, ntext, or image column in a work table.

That error message suggests to me that the problem lies in the SP,
rather than with the ADO.NET you are using to access it. Can you run
the SP from Query Analyzer? If you can't, you need to go to a SQL
Server group for help.