Kbase 21078: Error 1471 is seen with WHERE Clause against 'text' and 'ntext' data types in SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
MS SQL
SYMPTOM(s):
MS SQL 6.5
Error 1471 occurs when running a query
SYSTEM ERROR: Foreign database cursor not found. (1471)
Query uses a WHERE clause
Database migrated from Progress to MS SQL Server Database
Table data-type in SQL Server is "text"
Table data-type in SQL Server is "ntext"
CAUSE:
A WHERE clause cannot be used against fields that have "text" and "ntext" data- types, except with the "IS NULL" predicate. The migration utility creates these data type translations:
Progress Schema-Holder SQL Server
========= ============= ==========
Character x(1-255) VARCHAR VARCHAR
Character x(>255) LONGVARCHAR TEXT
FIX:
Do not use a WHERE clause against data type fields "text" and "ntext". But rather use a FIND with no text fields in the WHERE clause and then test later using the IF statement.