ALIAS( ) example

In this example, a function changes the index order of table of classes at a school:

PROCEDURE ClassesByRoom

   local cAlias 

   cAlias = alias( ) 

   select CLASSES 

   set order to ROOM 

   select ( cAlias ) 

This function saves the alias name of the currently selected table—which might be the table of teachers, students, or even the classes table—in the variable cAlias. When the function is done, that alias is reselected with the SELECT command, using the parentheses as indirection operators.