SUMMARY
An Unrecoverable Application Error (UAE) may occur in Q+E when you try
to do an extract from two external databases if one of the databases
contains more than 15 fields.
This behavior does not occur with Q+E and Excel 3.00 for OS/2; it only
occurs when accessing Excel for Windows worksheets.
MORE INFORMATION
The functionality to connect to external databases is provided by Q+E
and the add-in macro QE.XLA. For more information about the macro
functions provided by QE.XLA, see "Q+E for Microsoft Excel User's
Guide."
Steps to Reproduce Problem
- Create two databases, each on its own sheet, and define the
Database range on each sheet. Make one short (only two fields)
and the other long (20 or more fields).
- Make one of the fields common to both databases. The field
heading does not need to be the same but data in at least one
record must match to receive any records when the join is
performed. For this example, we called the first field "NAME"
and entered a record with the same name in each database.
- Save the first sheet as TEST1.XLS. Save the second as TEST2.XLS
- Open new worksheet.
- Open the QE.XLA add-in.
- Choose Set Database from the Data menu. Select External and choose
TEST1.XLS. Then choose the option Add and select TEST2.XLS.
- Enter the following:
A1 TEST1.NAME
A2 TEST2.NAME
- Highlight the range A1:A2 and choose Set Criteria from the Data
menu.
- To create the extract range, select cell A4 and choose Paste
Fieldnames from the Data menu.
- While the pasted range is still highlighted, choose Extract from
the Data menu. At this point the UAE will occur.
Extract seems to work consistently if the long database has 15 or
fewer fields. The UAE does not always occur at 16 fields. You may be
able to have up to 20 fields in the larger database before the UAE
occurs.
For more information, query on:
related and database and tables
REFERENCES
"Q+E for Microsoft Excel Users Guide," version 3.0, pages 58-63