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


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b
This article was previously published under Q148883

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.
Modification Type:MajorLast Reviewed:9/30/2003
Keywords:kbBug kbfix kbvfp500fix KB148883
©2003 Microsoft Corporation. All rights reserved.