dBASE IV Database Displays Y/N Logicals as Y/N in BROWSE

ID: Q124265

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a

SUMMARY

If 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 INFORMATION

dBASE 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 KBCategory: kb3rdparty kbprg KBSubcategory:

Last Reviewed: January 5, 1995