Kbase P37542: Getting 223 with MS SQL Server DataServer where field is a R
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/29/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
MS SQL 2000
SYMPTOM(s):
** Incompatible data types in expression or assignment. (223)
Getting error when compiling code against the MS SQL DataServer
Field in Progress is defined as data type RAW
Field in schema holder is defined as as a longvarchar
Field in SQL Server is defined as as a TEXT
Database was migrated using MS SQL Server Schema Migration tools
Can not change the RAW field definitions to CHAR before converting the database.
CAUSE:
RAW datatype is not currently supported in MS SQL Server DataServer.
FIX:
Transform the TEXT column in SQL Server to BINARY. Since there's not way to convert the existing column into a BINARY, you will need to do the following:
In SQL Server
1. Delete the TEXT column
2. Create a new BINARY column
3. Pull this new column into the schema holder
4. In schema holder, this new field is a BINARY (character)
5. Write a 4GL program to populate your data into this new BINARY field.