Kbase 20164: Trying to UPDATE an LVARBINARY Field Gives Error (7682)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1A
SYMPTOM(s):
Invalid long datatype column reference (7682)
Trying to UPDATE a LVARBINARY field.
CAUSE:
The LVARBINARY field was introduced in Progress Version 9.1A for SQL-92 tables to allow the storage of Binary Large Objects (BLOBs). Reading and writing to LVARBINARY fields is not the same as writing to other field types due to the unpredictable nature of information that can be contained in the LVARBINARY field, and to the complexity of handling such large amounts of data.
Because of the complexities of managing this potentially large amount of data, there are significant limitations on accessing LVARBINARY fields. These restrictions are listed in the SQL-92 Guide and Reference, Section 2.3.5, "Bit String Data Types".
One of the restrictions is that the SQL UPDATE statement cannot be used to modify a LVARBINARY field. If attempting to UPDATE a LVARBINARY field, Error (7682) will appear.
This error indicates that an operation was performed on a field type that is not supported. If this error is encountered, please check the documentation for any limitations on the field types trying to be access.
FIX:
Upgrade to 9.1B. Additionally, you can implement a workaround if you DELETE the row and INSERT it again, instead of using the UPDATE statement.