According to "Intelligent Query and IQ Access User's Guide", this error occurs when IQ could not open a supporting file, such as iqcap, iqconfig.dat, iqprtcfg.dat or the data dictionary file.

Please refer to "Intelligent Query and IQ Access User's Guide", appendix A for a detailed description.

These error numbers are documented in "Intelligent Query and IQ Access User's Guide for Windows and Motif" and "Intelligent Query and IQ Access User's Guide" appendix A.

The "Show Deleted Rows" option may be turned off from the ODBC FoxPro Setup screen.

When IQ for Windows is started with an empty data dictionary, like the distributed ddmaster.dat, it attempts to use the 16-bit ODBC driver. The above message is then reported if the ODBC driver is not installed. Please install the Microsoft 16-bit ODBC driver to avoid the above warning.

IQ for UNIX uses iqprtcfg.dat as the configuration file for background print.

IQ3 will not run with an IQ2 SSN and IQ3 reports ?reserved? mistakenly. A later version of IQ3 correctly reports a security violation.

IQ for Windows uses the 16-bit ODBC driver, instead of the 32-bit ODBC. Installing the 16-bit ODBC resolves this problem.

IQ has detected a 32-bit ODBC driver, instead of Microsoft?s 16-bit ODBC driver.

IQ performs a smart sort when the field being sorted is in the index of primary files. This process can be identified if the initial sort is completed in a single pass.

IQ performs a fast key search only on primary files. This process can be identified when the number of records processed is equal to the number of records found.

If a MRT record does not contain unique record identification, then it is defined as a default record type. A default record type must be the very last record type defined. In addition, it should be defined as a recurring record. The Record ID Code Type, Location, Sub-field Offset, and Storage Size must be set to zero (0), one (1), zero (0), and zero (0) respectively. Furthermore, the Record ID Code must also be set to zero (0).

Please refer to "IQ Data Dictionary Reference" manual for a detailed description.

The IQ User's Guide states "to create a subtotal that is a percentage in IQ for UNIX or Windows, you must multiply by 100 before dividing. For instance, to create a tuition percentage column rather than a tuition ratio column, perform the calculations in this order:

1. Multiply TUITION by 100 to get TEMP.

2. Divide TEMP by ORIG-TOTAL-DUE to get TUITION-PCT.

The proper order of the commands within your procedure would be:

MULTIPLY TUITION TIMES 100 GIVING TEMP.
DIVIDE TEMP BY ORIG-TOTAL-DUE GIVING TUITION-PCT."

On most Unix systems, using the "-a" option with cpio alters the "change time" on a file in UNIX on output. Do not use the "-a" option when backing up files in the /etc/DCI directory or skip the /etc/DCI directory when performing backups.

This problem can be avoided by using a hardware passport device.

IQ release 3, 4, and 5 support files types 0, 1, 3, 44, 261, 262, 263 (version 4 only), and 999. All other file types are NOT supported.

IQ versions 4 and 5 support dL4 date fields.

dL4 date fields are defined as field type 176. For "Field Size", use 2, 4 or 6 for 1%, 2%, and 3% date fields respectively. In addition, use Y0M0D9 for "Date Layout", 10 for "Output Size of Field", and use MM/DD/YYYY for "Output Format".

On Windows XP or later systems, the most common XVT errors are caused by incompatible printer drivers. Such XVT errors can occur even when a report is displayed only to the screen. Sometimes, the errors can be prevented by adding a printer in Windows using an older driver such as the HP LaserJet II and making that printer the default printer.

Because IQ for Windows has been discontinued, a better solution is to replace IQ for Windows with ODBCdL4 and an ODBC based report writer such as Crystal Reports. The ODBCdL4 server and driver provide ODBC access to UniBasic or dL4 data files. Current UniBasic or dL4 licenses include a license for ODBCdL4.