An error 7200 will occur when a data query is invalid. Causes of this error can include incorrectly formed SQL syntax, an invalid comparison operator in a query, and missing comparison criteria.

Note for Focus Reports Version 2: When a user does not have Office Hours appointment files, importing reports that use these files will produce a 7200 error. Reports affected include those in the Focus on Chiropractic group of reports.

Check these things in the query:

• If you are grouping in the query, all fields on the Fields tab must be included on the Group tab in the Query Designer
• When creating a data filter (the Search tab), you must either enter a Value for the filter or check the Show All box

If this error occurs when attempting to create a more complex query using the Query Wizard, try using the Query Designer instead.

If this error is the result of an SQL query you wrote yourself, check to be certain that the query is correctly formatted. Not all SQL statements are supported by the Advantage Database Server. For a complete list of supported SQL statements see the Advantage Streamline SQL help file included with the Advantage Data Architect (ARC32). The Advantage Streamline SQL documentation is also available in a .pdf file when you install Focus Reports Developer on the the Start > Programs > Inborne Technology menu.

More information is available from Extended Systems' Advantage Database support site at http://solutions.advantagedatabase.com.