Microsoft KB Archive/111056

Using $ or # in Table Name Affects DBF Name in Status Bar ID: Q111056 The information in this article applies to: Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b SUMMARY When you are opening a table in FoxPro, it is assigned a default alias, which is the name of the table. You can also use a user-defined alias to refer to the table. An alias can consist of up to 10 characters. Valid characters are letters, digits, or underscore characters; however, the alias must begin with a letter or an underscore character. MORE INFORMATION If a table/.DBF has a dollar sign ($), number sign (#), or any other invalid character in its alias name, and the table is open, the status bar shows A through J if the table is open in one of the first 10 work areas, or W11 through W225 if the table is open in one of the work areas between 11 to 225. Steps to Reproduce Behavior In the Command window, type the following: SELECT 1 && Select work area 1 CREATE TABLE tes#t (t1 c(20), t2 n(10,2)) && Create dbf && the status bar shows A USE IN 1 && Close tes#t table SELECT 200 && Select work area 200 USE tes#t && Open table tes#t && the status bar shows W200 USE IN 200 && Close tes#t table SELECT 10 && Select work area 10 USE tes#t && Open table tes#t && the status bar shows J The ALIAS() function returns the alias name shown in the status bar; however, the DBF() function returns the actual .DBF name and path information. REFERENCES "Language Reference," version 2.5, page L1-23 Additional reference words: FoxDos FoxWin Fox USE 2.50 2.50a 2.50b workareas database pound sign numbers numerals KBCategory: kbprg KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.