Knowledge Base

Works 3.0: Functions with Range Reference Cause GPF in Query

Article ID: 118751

Article Last Modified on 9/25/2003


APPLIES TO


This article was previously published under Q118751

SYMPTOMS

Attempting to use functions that require a range reference in a database query causes a general protection (GP) fault when the query is applied. Functions that require range references are not supported in the database query and should not be used.

RESOLUTION

Do not attempt to use a function that requires a range reference in any database query.

MORE INFORMATION

For more information about range references, please refer to the "References" section at the end of this article.

Steps to Reproduce Problem

  1. Open the WINGLIST.WDB sample file in Works.
  2. From the Tools menu, choose Create New Query. The New Query dialog box should appear.
  3. In the New Query dialog box, choose Query View.
  4. Delete the default value "=Date Entered=" from the Date Entered field.
  5. In the Credit Limit field, enter the formula =MIN(Credit Limit) and press ENTER.
  6. From the View menu, choose List.
A general protection (GP) fault occurs.

Microsoft has confirmed this to be a problem in Works for Windows versions 3.0, 3.0a, and 3.0b. This problem no longer occurs in Works 4.0 and later.

REFERENCES

For more information about how to perform this task in Works, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0, pages 198-203, "Using cell and range references in a formula"

Additional query words: general protection minimum maximum range BugList3.00 3.0 3.x gpf gen gp error message err msg mess

Keywords: KB118751