Microsoft KB Archive/98362

= Description of the differences between the MIN function and the MAX function and differences between the SELECT-SQL MIN field function and the MAX field function in FoxPro =

Article ID: 98362

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.6 for MS-DOS
 * Microsoft FoxPro 2.6a Standard Edition
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.6 Standard Edition
 * Microsoft FoxPro 2.6a Standard Edition
 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 8.0 Professional Edition
 * Microsoft Visual FoxPro 9.0 Professional Edition

-



This article was previously published under Q98362



SUMMARY
There are distinct differences between the MIN and MAX functions and the SELECT-SQL MIN and MAX field functions. The SELECT-SQL MIN and MAX field functions accept only one argument, whereas the MIN and MAX functions accept multiple arguments.

The following examples demonstrate how each function would be used in a FoxPro program.

SELECT MIN(price) from detail && This statement will select the record with lowest price && in the database.

SELECT MIN(IIF(price < 0,0,price)) FROM detail && This statement will select the record with the lowest price && as long as it is not less than zero; if it is less than zero, && it will return zero (0).

?MIN(54, 39, 40) && This statement will return the minimum of the three parameters && (39).

?MAX(54, 39, 40) && This statement will return the maximum of the three parameters && (54).

SELECT MIN(price,0) from detail && This statement will cause the error &quot; MISSING ) &quot; to occur.    && To correct this statement, remove the second argument from     && the MIN function, as shown in the first example. For Visual FoxPro 6.0 and later versions, use this code:

open database home(2)+&quot;data\testdata.dbc&quot; SELECT MIN(order_amt) from orders && This statement will select the record with lowest price && in the database.

SELECT MIN(IIF(order_amt < 0,0,order_amt)) FROM orders && This statement will select the record with the lowest price && as long as it is not less than zero; if it is less than zero, && it will return zero (0).

?MIN(54, 39, 40) && This statement will return the minimum of the three parameters && (39).

?MAX(54, 39, 40) && This statement will return the maximum of the three parameters && (54).

SELECT MIN(order_amt,0) from orders && This statement will cause the error &quot; MISSING ) &quot; to occur.    && To correct this statement, remove the second argument from     && the MIN function, as shown in the first example.

Additional query words: FoxDos FoxWin errmsg error message parameters err msg

Keywords: kbinfo KB98362

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.