Microsoft KB Archive/206461

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

Article ID: 206461

Article Last Modified on 10/31/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



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.



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).

