General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You would get equivalent results if you were saving the result into a cursor. VFP 8 would create an empty cursor while VFP 9 has a record with NULL values.
The results are the same with an empty source table or a WHERE clause that evaluates every record to .F.
BTW.......Did you move from Douglaston (I grew up with a Douglaston post office, but on the South side of the expressway, not in Douglaston proper)
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only