PRB: Screen Builder Truncates Format Expression with @R

ID: Q114969

2.50 2.50a 2.50b 2.60 | 2.50b 2.50c

WINDOWS               | MACINTOSH

kbprg kbprb

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6
Microsoft FoxPro for Macintosh, versions 2.5b, 2.5c

SYMPTOMS

If a picture expression is specified using #ITSEXPRESSION ~, and the expression contains an at sign ("@"), the expression will be truncated to the first occurrence of an at sign.

RESOLUTION

See "Workaround" in the "More Information" section below.

MORE INFORMATION

Steps to Reproduce Problem

1. In the Command window, issue the following commands:

      CREATE TABLE testexp (postalcode c(9))
      INSERT INTO testexp values ( '123456789' )

2. Create a screen and add the following to the Setup snippet:

     #SECTION 1
     #ITSEXPRESSION ~
        llUSA = .T.

3. Add an input field (GET) for TESTEXP.POSTALCODE.

4. Choose the Format button and add the following expression:

     ~ IIF(llUSA, "@R 99999-9999", "@R A9A 9A9")

5. Choose OK in the Format and Field dialog boxes.

6. Open the Field and Format dialog boxes again. The Format expression will

   be truncated and the "R" check box under Editing Options will be
   selected. If you run the screen generator, it will place this truncated
   picture clause in the generated code.

Workaround

Clear the "R" check box in the Format expression dialog box and change the Format expression to the following:

   ~ IIF(llUSA, "99999-9999","A9A 9A9")

Additional reference words: FoxWin 2.50 KBCategory: kbprg kbprb KBSubcategory: FxprgGeneral

Keywords          : FxprgGeneral 
Version           : 2.50 2.50a 2.50b 2.60 | 2.50b 2.
Platform          : MACINTOSH WINDOWS