I want to make a comparison between a sting that the user type and the data in my data base, but when I put that option and ask the program to count how many values it have it send the error "{"SQL Server does not handle comparison of NText, Text, Xml, or
Image data types."}"
internal static bool POexist(string p)
{
bool Flag = false;
if((from po in context.POs where po.PO1 == p || po.DESCRIPCION == p select po.ID_PO).Count() >0)
{
Flag = true;
}
faaguirre
0 Points
1 Post
{"SQL Server does not handle comparison of NText, Text, Xml, or Image data types."}
Jun 12, 2012 03:57 PM|LINK
I want to make a comparison between a
Hi,
I want to make a comparison between a sting that the user type and the data in my data base, but when I put that option and ask the program to count how many values it have it send the error "{"SQL Server does not handle comparison of NText, Text, Xml, or Image data types."}"
internal static bool POexist(string p)
{
bool Flag = false;
if((from po in context.POs where po.PO1 == p || po.DESCRIPCION == p select po.ID_PO).Count() >0)
{
Flag = true;
}
return Flag;
}
any idea?? Thanls
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: {"SQL Server does not handle comparison of NText, Text, Xml, or Image data types."}
Jun 18, 2012 02:03 AM|LINK
Yes，SQL really doesn't support comparasion in these very special types……I'm afraid you should change to type like nvarchar(max) instead……