Microsoft KB Archive/250669

= PRB: Wizard Causes "Variable Not Found" Error Messages When Adding Record =

Article ID: 250669

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q250669



SYMPTOMS
When you generate a One to Many form with the Microsoft Visual FoxPro 6.0 Form Wizard and attempt to add a record into the parent table with a key value that already exists, you might receive the error message listed below:

Uniqueness of index CUST_ID is violated.

Click the OK button three times and another error message appears:

SELECT (lnSaveAlias3)

Error: 12

Variable 'LNSAVEALIAS3' is not found.

Method: addrec

Line: 246

Click the OK button and another error message appears:

GO lnSaveRec3

Error: 12

Variable 'LNSAVEREC3' is not found.

Method: addrec

Line: 247



RESOLUTION
As a workaround, you can add the following code to the AddRec method of the txtBtns class. The txtBtns class can be found in VFP98\Wizards\wizbtns.vcx.  On the Tools menu, open the Class Browser. Click the Open button, locate wizbtns.vcx, and click OK. Click on txtbtns in the left pane of the Class Browser. Expand the Methods in the right pane and double-click on the AddRec method.  Go to line 29. This should be a blank line. The line above it should be: * Start of Code THIS.OldRec = RECNO  &&save record in case reverting   Add the following code: * Start of Code lnSaveAlias3 = ALIAS lnSaveRec3 = RECNO  Save wizbtns.vcx.</li></ol>
 * End of Code
 * Changes to prevent lnSaveAlias3 and lnSaveRec3 errors if added record already exists
 * End of Code

<div class="moreinformation_section">

Steps to Reproduce Behavior

 * 1) Run the Component Gallery.
 * 2) Open the folder named Visual FoxPro Catalog/Foundation Classes/Buttons.
 * 3) Select Data Edit Buttons and right click on it.
 * 4) Select View Sample, and then Run from the context menu. (If View Sample is disabled, set your Tools/Options/File Locations/samples directory correctly.)
 * 5) Click the Add/Save Record button.
 * 6) Click the Add record to both option.
 * 7) Type in ALFKI, and then click the Add button. Note that the errors listed in the "Symptoms" section occur.

(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Mark Barnard, Microsoft Corporation.

Keywords: kbcodesnippet kbdatabase kbprb kbwizard kbpending KB250669

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.