>>* Test2 >>CLOSE DATABASES ALL >> >>CREATE CURSOR Test1 ( Char1 C( 10 ) ) >>* We purposefully leave no rows in the first cursor >> >>CREATE CURSOR Test2 ( Char1 C( 10 ), OrderCol I ) >>INSERT INTO Test2 ( Char1, OrderCol ) VALUES ( "One", 1 ) >>INSERT INTO Test2 ( Char1, OrderCol ) VALUES ( "Two", 2 ) >>INSERT INTO Test2 ( Char1, OrderCol ) VALUES ( "Three", 3 ) >>INSERT INTO Test2 ( Char1, OrderCol ) VALUES ( "Four", 4 ) >>INSERT INTO Test2 ( Char1, OrderCol ) VALUES ( "Five", 5 ) >> >>* Purposely set the currently selected table to >>* the first cursor instead of Test2 to see if we can fool RECNO(): >>SELECT Test1 >> >>SELECT ; >> * ; >> , RECNO( "DerivedTable" ) AS MyRecNo ; >> FROM ; >> ( SELECT ; >> * ; >> FROM Test2 ) DerivedTable ; >> INTO CURSOR Output ; >> ORDER BY OrderCol >> >>* Result: Program error: "Alias is not found". But, we're explicitly referencing >>the alias of the derived table! Shouldn't this work? < g > >>