Kbase P15985: Error# 223 when trying to update a timestamp SQL-92 field us
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2003 |
|
Status: Unverified
SYMPTOM(s):
Created an SQL-92 table that contains a timestamp field under the PUB schema.
Attempting to assign a value to the timestamp field using Progress 4GL.
** Incompatible data types in expression or assignment. (223)
CAUSE:
Not all the SQL-92 data types such as TIMESTAMP are supported by the 4GL.
FIX:
Make sure that there is no incompatible data types between SQL-92 and Progress 4GL before creating SQL tables under PUB and letting 4GL access it.