>An array will only be created when query returns non-zero # records. >The ANSI SQL standard requires that query with aggregate function >return a record with Nulls for empty result set. VFP9 is now compliant >with the standard in this part.

>CREATE CURSOR testxx (ii int, cc char)
>SELECT * FROM testxx INTO CURSOR crsTest
>? _TALLY && 0 - still returns zero because thre're no aggragate >functions
>SELECT SUM(ii) AS sum1 FROM testxx INTO CURSOR crsTest
>? _TALLY, sum1 && 1, Null
>SELECT MAX(ii) FROM testxx INTO CURSOR crsTest
>? _TALLY && ? _TALLY, sum1 && 1, Null

Hi Sergey,

Thanks for further clarifying this point.

John