DOCUMENT:Q154980  14-DEC-1999  [foxpro]
TITLE   :PRB: Non-updateable View Generates Warnings in Form Wizard
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:3.0,3.0b
OPER/SYS:
KEYWORDS:

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

 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b 
-------------------------------------------------------------------------------

SYMPTOMS
========

When running a form created using the Form Wizard, the following warning may be
displayed:

   Edits to one or more of the views may not be permanent. To remedy this,
   ensure the View's Send SQL Updates checkbox is checked in the View Designer.

CAUSE
=====

The form was created from one or more views that have not been made updateable.

WORKAROUND
==========

In order to avoid this warning, you may implement one of the following
workarounds. It is important to recognize that neither of these two workarounds
allows changes to be made to the data; they merely provide a method of avoiding
the warning message.

1. Make at least one field in the view updateable, and check the "Send SQL
   Updates" checkbox.

2. Modify the txtbtns class (included in Wizstyle.vcx) so that it will not
   display the warning. Open the txtbtns class in the visual class designer, and
   comment out the following lines of code in the Initvars method:

      IF !CURSORGETPROP("SendUpdates",.Alias) AND !m.lShowedMess
         =MESSAGEBOX(C_NOUPDATEVIEW_LOC)
         lShowedMess = .T.
      ENDIF

Note: Modifying this class will affect every form that is created with the Form
Wizard.

STATUS
======

This behavior is by design.

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

The Form Wizard was designed to create data-entry forms. It is assumed that you
will want to make changes to the data that the form is based on. Therefore, as
the form is loading, it checks to see if any views that are part of its data
environment are non-updateable (read-only). If non- updateable views are found,
the above warning is displayed.

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

1. Create a local or remote view in the View Designer. Make certain that the
   "Send SQL Updates" checkbox is not checked.

2. Run the Form Wizard, and create a form based on the view that was just
   created.

3. Run the newly created form. Note that the warning message is displayed.

Additional query words: kbdse VFoxWin

======================================================================
Keywords          :  
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b
Version           : WINDOWS:3.0,3.0b

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

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.