>Hi Al,
>
>You shouldn't use an alias in RECNO() or similar functions because a query always uses internal alliases for tables involved. If you do, than you reference an alias outside of a query.

Sure, that's what my testing just showed. Even explicitly calling the alias of the derived query tries to go outside (my Test #2). It just shows that these two overloads of RECNO() have different behaviour.

>>

>>* 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 >
>>