Upon further investigation, I have discovered that the problem with SQL Select and arrays only occurs when using a function is the Select statement.

Run the following code in VFP 9.0:

SET ENGINEBEHAVIOR 90

CREATE CURSOR test (ky i)
SELECT MAX(ky) FROM test INTO ARRAY laTest

debug
SUSPEND

Examine the contents of laTest in the Locals window. The result will be null. Now run this code:

SET ENGINEBEHAVIOR 80

CREATE CURSOR test (ky i)
SELECT MAX(ky) FROM test INTO ARRAY laTest

debug
SUSPEND

The array is not created.

Now run the following:

SET ENGINEBEHAVIOR 90

CREATE CURSOR test (ky i)
SELECT ky FROM test INTO ARRAY laTest

debug
SUSPEND

The array is not created.