Kbase 18030: Validation of Workfiles from V6 to V8
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/1998 |
|
Validation of Workfiles from V6 to V8
DRAFT COPY - Currently under review and edit.
INTRODUCTION:
=============
This Technical Support Knowledgebase entry describes one of the
implications of migrating a V6 application to V8 character in respect
of validation of workfiles.
Under Progress version 6, the validation from the database table was
carried to the workfile when defined LIKE the database table.
Therefore, workfiles are to database tables what variables are to
database fields.
The validation for the workfile was taken from the LIKE database table
however, V7 and above do not carry forward this functionality by
default. As stated in the Programming Handbook, "Work tables also
have the option to adopt the same dictionary validation specified for
the corresponding database table".
PROCEDURAL APPROACH:
===================
In order to take advantage of the validation it is necessary to amend
your procedure as follows by adding VALIDATE:
DEFINE WORKFILE wf-cust LIKE customer VALIDATE.
However, where you have the following layout, the validation no longer
exists:
DEFINE WORKFILE wf-cust
FIELD wf-cust-num LIKE customer.cust-num.
Therefore, it is necessary to consider this when migrating
applications. In order to resolve this, it would be necessary to
amend the code to place such validation on the FORM statement.
Attempting to use the statement VALIDATE with the second example,
would result in error:
** Unable to understand after - "<string>" (247)
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Programming Handbook chapter 14 Temporary Tables & Work Tables
Elizabeth Bellingham
17 June 1998