Table & Alias Names Not Always the Same in FoxPro for Mac

   USE "Macintosh HD:Long Database Name.DBF"
   ? ALIAS()
				

MORE INFORMATION

FoxPro transforms Macintosh-like table names to Windows/MS-DOS-like aliases, with an underscore (_) substituted for the spaces allowed in Macintosh filenames. For example, in FoxPro for Macintosh, the table name "my table" would have the alias "my_table".

Several functions that use work area aliases work only on alias names as rendered by FoxPro. For example, "my table" has the alias "my_table"; thus, FLOCK("my_table") works, but FLOCK("my table") generates an error.

In addition to the underscore substitution for spaces, filenames longer than 10 characters are truncated to the first 10 characters.

The following is a list of FoxPro functions and commands that operate with alias names rather than table names:

   ALIAS()                         ORDER()
   BOF()                           RECCOUNT()
   CDX()                           RECNO()
   DBF()                           RECSIZE()
   DELETED()                       RELATION()
   EOF()                           RLOCK()
   FCOUNT()                        SEEK()
   FIELD()                         SELECT <specified work area>
   FILTER()                        SET RELATION
   FSIZE()                         SET SKIP
   FLOCK()                         SKIP
   GO/GOTO                         SYS(14)
   JOIN                            SYS(2021)
   KEY()                           TAG()
   LOCK()                          TARGET()
   LUPDATE()                       UNLOCK
   MDX()                           USED()
   NDX()