Run the code below. How many times is the function FOO called? Why?
The first SELECT is a single table query. The next is a 2 table self-join with no join condition.
CREATE CURSOR test (name c(10))
FOR i = 1 TO nRecs
INSERT INTO test VALUES ("test"+TRANSFORM(i))
SELECT name,foo(name) AS foo FROM test INTO CURSOR result
?"Count = ",nCount
CLOSE DATABASES all
SELECT a.name,foo(a.name) AS foo FROM test a, test b INTO CURSOR result