dBASE IV Database Displays Y/N Logicals as Y/N in BROWSELast reviewed: January 5, 1995Article ID: Q124265 |
The information in this article applies to:
SUMMARYIf a dBASE IV version 2.0 database has logical fields with Y or N values, both dBASE and FoxPro version 2.6 for MS-DOS display the logical values as Y or N instead of T or F. If you want all values consistent in the database, use the REPLACE command to change the Y values to T and the N values to F.
MORE INFORMATIONdBASE IV version 2.0 can store Logicals as either Y/N format or T/F format, as can FoxPro. Even though the BROWSE commands in both products display Y or N logical values as Y or N, using LIST or ?<logical_field_name> yields a .T. or .F.. Therefore, you can replace the Y or N values with actual T or F values by using the REPLACE command. For example, if the logical field in a database is called LOG1, use the following command to replace all N values with F values:
REPLACE ALL log1 with .f. FOR log1 = .f.FoxPro will not convert the logical Y or N values to T or F values because FoxPro views the database as a regular dBASE III+-compatible file with nothing unusual in it.
|
Additional reference words: FoxDos 2.50 2.50a 2.50b 2.60 2.60a conversion
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |