Alias operator example

The following program opens two tables that both have a field named City and creates both private and local variables named City:

use CUSTOMER // Open in current work area

use CUSTOMER // Open in current work area

use VENDOR2 in select( ) alias VENDOR // Open in another work area with alias

private city // Names are not case-sensitive

city = "Peoria" // Alias not required because assignment does not assign to fields

? "No alias:", city // Field from current table

exerciseAliasOp( )

use in VENDOR // Close tables

use

function exerciseAliasOp( )

   local city 

   city = "Louisville" 

   ? "Local defined, no alias:", city // Local variable 

   ? "M alias:", m->city // Private variable hidden by local 

   ? "Customer:", customer->city // Field from table 

   ? "Vendor:", vendor->city // Field from other table