Microsoft KB Archive/135624

{| = How to Add Table Fields to Screen Wizard-Generated Screens =
 * width="100%"|

ID: Q135624

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.6, 2.6a
 * Microsoft FoxPro for Windows, versions 2.6, 2.6a

SUMMARY
This article shows by example how to add a table field to a Screen Wizard- generated screen while addressing the conventions that will help to ensure that the change does not conflict with the screen's original functionality.

Sometimes it is desirable to add table fields to a Screen Wizard- generated screen program. This is particularly true if the Screen Wizard did not incorporate all the table fields when it created the original screen or if new fields were added to the table after the Screen Wizard was initially run.

The generated code that drives a Screen Wizard-generated screen is very complex. Making even the slightest change to it can easily induce problems with the screen's original functionality.

Things to Know About the Field to Be Added

 * Data type (this example covers character, numerical, and date fields).
 * Field size for character and numerical fields.

Steps to Create the Example Screen Wizard-Generated Screen
1. Start FoxPro, and on the Run menu, click Wizard and then Screen.

2. In the Screen Wizard, click the Open button. In the Tutorial

subdirectory of the FoxPro root directory, select the Customer.dbf table, and then click Next. 3. For the Selected Fields, click the Add All option. Once all of the fields have been added, remove one for this example. At the bottom of  the Selected Fields list, select Long and then click the Remove button. Click Next. 4. For the Sort Order of Records', highlight the Cno field and then Add. Click Next. 5. Choose the Standard style. (With the Windows, version, select the  Text button type.) Click Next. 6. For the title, enter whatever title you wish. Click the 'Modify screen with design tool' option and then Finish. 7. If you wish to save this as something other than Customer.scx enter whatever you like. Then click the Finish button. Upon completion, you will be taken directly to the Screen Editor.

Steps to Add the Field
1. On the Screen menu, click Field in MS-DOS, or select the Field tool

in Windows). 2. The Field type is Get. 3. In the area to the right of the Get button (MS-DOS) or to the right

of the Input button (Windows), type m.long.

NOTE: Wizard Screens create memory variables for all of the fields of the table. All of these variables are named for the field they represent and have an m. prefix. 4. Click the When button. Then choose Expression, and place the cursor inside the area below. Type "isediting" (without the quotation marks), and click OK. 5. Select Format and choose Character. In the area below format, type 999.9999. Then choose OK to close the Format window and OK again to  close the Field window.

NOTE: The Long (longitude) Field is actually of a Numerical data type. The Character Type Format for this is a Wizard Standard. The 999.9999 is derived from the Data Type as Numerical, 8 places total (including the decimal) with 4 places to the right of the decimal. If this had been a Character Type Field, the Format would have been composed of a number of upper case X that corresponds to the field width. For example, a five Character wide field would have a  format of XXXXX. For a Data Type of Date, the Character Type Format still applies, but nothing should be entered into the format box. 6. Place the new field wherever you like on the Screen. In Windows, you may wish to highlight the field, and select the Object menu to change the Fill Color and Font to match the other fields on the screen. 7. To make a title in MS-DOS, type it on the screen. To do this in Windows, highlight, copy (CTRL-C), and paste (CTRL-V) one of the other titles; then double-click the copy and change the Output. 8. On the Program menu, click Generate and then Yes to save changes. Then click Generate again in the Screens/Screen Set Window. This final step produces a Screen Program that is derived from a  Screen Wizard .scx file. Additional reference words: 2.60 2.60a FoxWin FoxDos KBCategory: kbtool KBSubcategory: FxtoolWizscreen
 * }