Q218457: BUG: Custom Expression Builder Crashes Query and View Designers

Article: Q218457
Product(s): Microsoft FoxPro
Version(s): WINDOWS:6.0
Operating System(s): 
Keyword(s): kbDesigner kbvfp600bug kbXBase
Last Modified: 12-MAR-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, version 6.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

If a custom expression builder is defined with the system variable _getexpr, the
Query/View Designer crashes with the following error:

  Fatal error: Exception code=C0000005

RESOLUTION
==========

Use GETEXPR() in the Command window to obtain the expression. Run the following
code from the Command window, and then press CTRL-V to paste the text into the
Functions and expressions text box of the Designer:

  GETEXPR() TO x
  _cliptext = x

STATUS
======

Microsoft has confirmed this to be a bug in the Microsoft products listed at the
beginning of this article.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. Create a new form. Add a text box and a command button to the form.

2. Enter the following code in the command button's Click event:

  gcExpr = Thisform.Text1.Text
  Thisform.Release

3. Set the following form properties:

  AlwaysOnTop True (.T.)
  Desktop True (.T.)
  WindowType 1 ? Modal

4. Save the form with the file name "MyGetExpr".

5. Create a new program file and enter the following code:

  PARAMETERS cExpressionType, cErrorMessageText, cDefaultExpression, cCaptionText

  PUBLIC gcExpr
  gcExpr = ""
  Do Form MyGetExpr
  return gcExpr

6. Save the program file with the file name "MyGetExpr.prg".

7. In the Command window, enter the following code:

  _getexpr = "MyGetExpr"
  CREATE QUERY

8. When the Open dialog box displays, press the ESC key.

9. Click the ellipsis next to the Functions and expressions field.

RESULTS: Visual FoxPro displays the error message listed in the SYMPTOMS section.

REFERENCES
==========

For additional information about custom expression builders, please see the
following article in the Microsoft Knowledge Base:

  Q218453 Custom Expression Builder Value is not Accepted in Report Designer

(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Mike A.
Stewart, Microsoft Corporation.



Additional query words:

======================================================================
Keywords          : kbDesigner kbvfp600bug kbXBase 
Technology        : kbVFPsearch kbAudDeveloper kbVFP600
Version           : WINDOWS:6.0
Issue type        : kbbug
Solution Type     : kbpending

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1986-2002.