Kbase 18622: Apptivity - Data Source Updates When Migrating 2.1 to 3.x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
This document applies to: Apptivity Developer and Runtime
Version and Release Number: 3.0 and above
SUMMARY:
When projects created with Apptivity 2.1 are migrated to
Apptivity 3.x, for each Data Source, the user must edit the SQL select
statement and save the Data Source.
EXPLANTION:
In Apptivity 3.0, fields were added to the columntag structure. This
change was necessary for the runtime to correctly handle updating of
records.
So, for successful migration from 2.1 to 3.x, it is necessary that the
user edit the SQL select statement (e.g., type a character then delete
the character) in the Data Source's properties, and save each Data
Source explicitly so that the required metadata can be extracted from
the database engine.
If this is not done, updating records may not be allowed. An attempt
to update may not be succesful, and may result in the following
message:
Updates not allowed on <Data Source name>
statement could not be prepared, changed cancelled
References To Written Documentation:
Apptivity 3.0.1 Release Notes