DOCUMENT:Q164387 25-AUG-1999 [foxpro] TITLE :PRB: Send SQL Updates is Checked but Data Not Saved PRODUCT :Microsoft FoxPro PROD/VER:3.0 3.0b 5.0, 6.0 OPER/SYS: KEYWORDS:kbvfp kbvfp300 kbvfp300b kbvfp500 kbvfp600 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 6.0 ------------------------------------------------------------------------------- SYMPTOMS ======== When adding a record to a remote view, sometimes the record does not appear in the table after updating. Or the following error may occur when trying to close the view: Table buffer for alias contains uncommitted changes Even though the "Send SQL Updates" box is checked in the Update Criteria tab of the view, make sure that the Updateable (marked with a pencil symbol) column for the primary key is checked also. STATUS ====== This behavior is by design. MORE INFORMATION ================ Depending on the rules that are applied to a table, many times a rule requires that the primary key field of a new record must have a value placed into it before the record is saved. It is often assumed that while in the Update Criteria tab of the View Designer, selecting a primary key field in the Field Name list box and then clicking the Update All button updates the primary key and all other fields in the list box. This is not entirely true; while all of the other fields have the Updatable column (marked with the pencil symbol) checked, the Updateable column of the primary key is not checked. It has to be checked manually in order for the primary field to be updated. If the primary key field is not checked, this causes the record not to be added to the table. Steps to Reproduce Behavior --------------------------- 1. Open a database. 2. From the File menu, click New. Click Remote View and click New. 3. Select a connection or data source in the list box and supply the correct information to connect. 4. Add a table from the list box. 5. In the Fields tab, select all records. 6. In the Update Criteria tab, check the Send SQL Updates box and make sure that there is a primary key checked. Click Update All to select all of the fields to be updated. 7. Run the view and click Append New Record from the Table menu. Add data to the fields and close the Browse window. 8. Close the view after naming it; reopen and run it. Note that the record that you added is not there. By going into the View Designer and checking the Updatable column on the primary key field, a record can now be added to the table. Note that if the table that the view is created on does not have rules that the primary key field must have a value in it. It is then possible to add a record but the primary key field is left blank. Additional query words: ====================================================================== Keywords : kbvfp kbvfp300 kbvfp300b kbvfp500 kbvfp600 Technology : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b kbVFP500 kbVFP600 Version : 3.0 3.0b 5.0, 6.0 ============================================================================= 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.