FIX: Setting the Value of a Text Box Adds New Record to Table

 Last reviewed: February 20, 1997
Article ID: Q148883
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b

SYMPTOMS

When you programmatically set the Value property of a text box that has its ControlSource property set to a field in a table, a new record will be added to the table if the record pointer is positioned at the end of file.

WORKAROUND

If the Value property of a text box is to be set programmatically, use the EOF() function to determine if the record pointer is positioned at the end of file before setting the Value property.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.

MORE INFORMATION

Steps to Reproduce Problem

  1. Create a new form.

  2. Add a table to the data environment of the form.

  3. Drag a character field from the table in the data environment to the form.

  4. Add a command button to the form.

  5. Add the following code to the Click event of the command button:

    GO BOTTOM SKIP 1 This.Parent.Text1.Value='test'

  6. Save and run the form.

After you click the command button, a new record is added to the table, and the field that was used to create the text box on the form has a value of test.

KBCategory: kbtool kbbuglist kbfixlist
KBSubcategory: FxtoolFormdes VFoxWin buglist3.00 buglist3.00b fixlist5.00
Additional reference words: 3.00 3.00b

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.

Last reviewed: February 20, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.