Kbase 11208: HOW TO DEFINE AS MANY JOINS AS POSSIBLE IN RESULTS IN .QC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
HOW TO DEFINE AS MANY JOINS AS POSSIBLE IN RESULTS IN .QC
Unisys 6K/65 (2,,,921103-35162,gfsSome users construct their own .qc file for RESULTS, or have many
files for which relationships are defined. Too many joins can cause
system error 444 "Attempt to expand record beyond the maximum allowed
size." Some recommendations for a workaround:
o Make sure that you include only 1 reference to a relation
(e.g. Use CUSTOMER,ORDER and does not include ORDER,CUSTOMER)
o A rough test to see how many bytes your joins will take up is add up
the number of bytes in the text in the .qc file defining the joins.
This should not exceed 30KB.
o Shorter filenames and database names count and may allow you more
joins if they are small in length.
o Remove extra spaces in WHERE clauses.
The above steps should allow you to maximize the number of joins in
your .qc file.
Progress Software Technical Support Note # 11208