Kbase P131676: Getting error 5729 when trying to copy data from VST in 10.1B database to variable defined in 10.1A
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/16/2009 |
|
Status: Unverified
SYMPTOM(s):
Getting error 5729 when trying to copy data from VST in 10.1B database to variable defined in 10.1A AppServer client.
Getting error 5729 when trying to copy data from VST in 10.1B database to temp-table defined in 10.1A AppServer client.
Incompatible datatypes found during runtime conversion. (5729)
FACT(s) (Environment):
Database was recently created in 10.1B03.
10.1B client does not generate this error when running the same code.
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
A 10.1A AppServer may connect remotely to a 10.1B Database.
The 10.1A AppServer may display data from the VST's or MetaSchema of the 10.1B database but certain operations may generate this message.
Creation of a temp-table "LIKE" a physical table in the 10.1B database which has fields defined as INT64 datatype will generate the (5729) error.
Attempting to assign the values of INT64 fields to a 10.1A INT field may fail unless an explicit typecast is made.
FIX:
Example of how to successfully store a field value from an INT64 field into an INT field when a 10.1A client is remote-connected to a 10.1B database:
DEFINE VARIABLE myint AS INTEGER NO-UNDO.
FOR EACH _connect.
ASSIGN myint = INTEGER(_connect-id).
DISP myint.
END.