Knowledge Base

PRB: Expression Builder in Query Designer Uses Incorrect MIN and MAX Functions

Article ID: 206461

Article Last Modified on 10/31/2000

APPLIES TO

This article was previously published under Q206461

SYMPTOMS

Selecting the MIN(,) and MAX(,) functions in the expression builder of the Query Designer gives the incorrect format of the command. This results in the following error when trying to verify the expression:
Function Name is Missing ).

CAUSE

The expression builder incorrectly adds a comma to the function. The MIN() and MAX() functions used in SQL receive only one parameter, while the native Visual FoxPro MIN(,) and MAX(,) functions compare multiple parameters passed. For more information on the differences between the commands, please see the "References" section below.

RESOLUTION

After you select either the MIN() or MAX() command in the expression builder, remove the comma and use only one parameter.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open Query Designer.
  2. Click the Expression Builder at the Functions and Expressions box in the lower left corner.
  3. From the Math drop-down list box, select MIN(,) or MAX(,).
  4. Place a numeric expression on each side of the comma.
  5. Click the Verify button (which causes the error mentioned above) or try adding the expression to the Selected fields list box (which places quotes around the expression).

REFERENCES

98362 INFO: Differences Between MIN(), MAX(), and SQL SELECT MIN/MAX

Keywords: kbnofix kbxbase kbdesigner kbprb kbbuilder kbquery KB206461


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.