Kbase P98763: Error (6176) when the expression specified in a MATCHES operator is longer than field width defined
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
MS SQL DataServer
MS SQL
SYMPTOM(s):
Progress returns the following error:
An overflow of a character value. (6176)
MS SQL returns the following error:
22001: string data, right truncation
Using the following 4GL code:
FIND LAST <table> WHERE <field> MATCHES <expression>
<expression> is longer than the field width defined in MS SQL
CAUSE:
Bug# 20031217-001
FIX:
Upgrade to 9.1E or later.
Upgrade to OpenEdge 10.0B or later.