DOCUMENT:Q218457  12-MAR-1999  [foxpro]
TITLE   :BUG: Custom Expression Builder Crashes Query and View Designers
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:6.0
OPER/SYS:
KEYWORDS:kbDesigner kbvfp600bug kbXBase

======================================================================
-------------------------------------------------------------------------------
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 1999.