How to Browse with Mixed Read-Only and Read/Write Fields

ID: Q107195

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

The BROWSE FREEZE command allows a single field in a Browse window to be modified, with the remainder of the fields automatically browsed as read- only fields. It is often desirable to have a mixture of several fields that are read-only and several fields that are read/write in the Browse window. There are three methods (described below) that can be used to accomplish this.

MORE INFORMATION

The three methods below browse the FOXPRO\TUTORIAL\CUSTOMER database, with the CNO, COMPANY, and YTDPURCH fields being read-only, and the CONTACT, ADDRESS and CITY fields being read/write.

Method 1: Using the BROWSE FORMAT Command

A format file can be used to control the Browse window. The row and column positions are not important. To browse a read-only field, place an @ ... SAY <field> command in the file. To browse a read/write field, place an @ ... GET <field> command in the file. If a read/write field has a PICTURE, WHEN, or VALID clause associated with it, add the clause at the end of the @ ... GET command in the format file.

1. Create a format file using the following command:

      CREATE FILE customer.fmt

      @ 1,1 SAY cno
      @ 2,2 SAY company
      @ 3,3 SAY ytdpurch
      @ 4,4 GET contact
      @ 5,5 GET address
      @ 6,6 GET city

   file:

      SET FORMAT TO customer.fmt

      BROWSE FORMAT

   following command:

      CLOSE FORMAT

Method 2: Using Calculated Fields on the BROWSE STATEMENT

The second method involves using a calculated field on the BROWSE command itself for each read-only field desired. This method takes fewer steps; however, it requires that a calculated field name be created for each read- only field. For example, issue the following command:

   BROWSE FIELDS ;
      custno=cno, companynm = company, yrlypurch = ytdpurch, ;
      contact, address, city

Method 3: Using the :R Option with a Fields List

The third method involves using a read-only (:R) specifier for each field that should be read-only. For example, issue the following command:

   BROWSE FIELDS ;
      cno:R, company:R, ytdpurch:R, ;
      contact, address, city