Kbase 14014: Results V6 - Shrink r-code building query forms - 63k limit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Results V6 - Shrink r-code building query forms - 63k limit
DRAFT COPY - Currently under review and edit.
INTRODUCTION:
=============
Progress has a limit on r-code of 63K per module. The following are
hints of how to shrink the size of the r-code when building query
forms in PROGRESS Results V6.
WHY YOU NEED TO KNOW THIS:
===========================
When doing an initial build with Results V6 it will not successfully
complete if any of the query forms exceed the 63K limit.
PROCEDURAL APPROACH:
====================
Reasons r-code larger than 63K:
- PROGRESS makes r-code big if there are a lot of fields in the file
Whether those fields are actually referenced is irrelevant.
- Big validation expressions
- Long help messages and/or validation messages
- In V6 decimal items with Query enabled expand to a complicated
expression to support "." or "," as the decimal character
- Complicated forms and/or long labels
- Long formats
Ways to shrink r-code:
You must build the query form manually.
- Eliminate fields that are not necessary to see on the screen
- Consider using one form for Query and a different one for
Add/Update/Copy
- Eliminate all Browse fields. (Say "no" to the "Brow?" column in
"Admin->Form Definitions->Which Fields")
- Eliminate all Add/Update/Copy fields. (Say "no" to the "Upd?"
column in "Admin->Form Definitions->Which Fields")
- Eliminate all Query fields, and use the Where option instead.
(Say "no" to the "Qry?" column in "Admin->Form Definitions->
Which Fields")
ONLINE PROCEDURES OR UTILITIES:
===============================
REFERENCES TO WRITTEN DOCUMENTATION:
====================================
Progress Software Technical Support Note # 14014