Re: The data types varchar and text are incompatible in the equal to operator
- From: "Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 10 Nov 2006 11:04:08 -0500
"value" is Variant.
Try
param[0].Clear ;
Or
param[0].value := Null ;
-Steve-
"AdamStefanCosta" <adam9000@xxxxxxxxxxxxxx> wrote in message
news:45548519@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Community
In a MIDAS application, TClientDatasets with String params set equal to blank
(...param[0].value='') generates the follow error when I convert my
ApplicationServer to ADO:
"The data types varchar and text are incompatible in the equal to operator"
In BDE this error do not exists...
Are there some parameter in ADO Connection String to supress this error? Are
ansi null related problem???
SQLServer2k5 | ADO Broker (D7) | ISAPI InternetExpress (D5)
Thx in Advance...
.
- Follow-Ups:
- Re: The data types varchar and text are incompatible in the equal to operator
- From: AdamStefanCosta
- Re: The data types varchar and text are incompatible in the equal to operator
- References:
- The data types varchar and text are incompatible in the equal to operator
- From: AdamStefanCosta
- The data types varchar and text are incompatible in the equal to operator
- Prev by Date: Re: SQL Parameters
- Next by Date: Re: The data types varchar and text are incompatible in the equal to operator
- Previous by thread: Re: The data types varchar and text are incompatible in the equal to operator
- Next by thread: Re: The data types varchar and text are incompatible in the equal to operator
- Index(es):
Relevant Pages
|
