The data types varchar and text are incompatible in the equal to operator

From: "AdamStefanCosta" <adam9000@xxxxxxxxxxxxxx>
Date: Fri, 10 Nov 2006 11:59:58 -0200

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: Kevin Frevert
- Re: The data types varchar and text are incompatible in the equal to operator
  - From: Steve Zimmelman
- Re: The data types varchar and text are incompatible in the equal to operator
  - From: AdamStefanCosta

Prev by Date: Re: Could not convert variant of type (NULL) into type (String)
Next by Date: Re: The data types varchar and text are incompatible in the equal to operator
Previous by thread: Could not convert variant of type (NULL) into type (String)
Next by thread: Re: The data types varchar and text are incompatible in the equal to operator
Index(es):
- Date
- Thread

Relevant Pages

Re: The data types varchar and text are incompatible in the equal to operator
... TClientDatasets with String params set equal to blank ... ApplicationServer to ADO: ... Are there some parameter in ADO Connection String to supress this error? ...
(borland.public.delphi.database.ado)
Re: ADO Add Column
... deficiencies, i.e., providing full DAO creation/manipulation for all ... ACCDB data types? ... it's still not up to the rich ANSI-92 Query Mode SQL DDL ... syntax as used by the OLE DB provider (e.g. via ADO). ...
(microsoft.public.access.formscoding)
Re: The data types varchar and text are incompatible in the equal to operator
... I don't know exactly where it is (an issue with ADO? ... Where SomeValue LIKE:SomeValue ... TClientDatasets with String params set equal to ... Thx in Advance... ...
(borland.public.delphi.database.ado)
ADO Vs ODBC Data types and formatting.
... I am replacing a VB5 application that handles database communication ... directly through ODBC API calls with a VB5 application that uses ADO ... I am having some issues with mapping the data types returned by ODBC ...
(microsoft.public.sqlserver.odbc)
ADO Vs ODBC Data types and formatting
... I am replacing a VB5 application that handles database communication ... directly through ODBC API calls with a VB5 application that uses ADO ... I am having some issues with mapping the data types returned by ODBC ...
(microsoft.public.vb.database)