Microsoft KB Archive/319284

= FIX: Record Count Reset When You Run END TRANSACTION Command Against a Remote View =

Article ID: 319284

Article Last Modified on 4/11/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 7.0 Professional Edition

-



This article was previously published under Q319284



SYMPTOMS
When you requery a remote view to which you have appended records, and then you append additional records in the transaction, some or all of the appended records are missing when you reach the END TRANSACTION line.



RESOLUTION
To resolve this problem, obtain the latest service pack for Visual FoxPro for Windows 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

316964 How to Obtain the Latest Visual FoxPro for Windows 7.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft Visual FoxPro for Windows 7.0.

This problem was first corrected in Visual FoxPro for Windows 7.0 Service Pack 1.



Steps to Reproduce the Behavior
Paste the following code in a program (.prg) file, and then run the program from the Command window of Visual FoxPro 7.0 build 9262: CLOSE DATABASES all CLEAR

CREATE TABLE testTable (cField1 C(10)) USE
 * !* Create sample data
 * !* Create sample data

CREATE DATABASE testDBC CREATE CONNECTION testConn ; CONNSTRING &quot;Driver={Microsoft Visual FoxPro Driver};&quot; + ; &quot;SourceDB=&quot; + SYS(5) + CURDIR + &quot;;SourceType=DBF&quot; CREATE SQL VIEW testView CONNECTION testConn AS ; SELECT * ; FROM testTable CLOSE DATABASES ALL
 * !* Note: This view cannot be updated.

? &quot;Without Buffering&quot;
 * !* Behavior without buffering.
 * !* Behavior without buffering.

OPEN DATABASE testDBC USE testView

APPEND BLANK REQUERY ? RECCOUNT
 * !* The APPEND BLANK command and REQUERY function trigger the behavior.

BEGIN TRANSACTION APPEND BLANK APPEND BLANK ?RECCOUNT

END TRANSACTION ?RECCOUNT CLOSE DATABASES ALL

? &quot;With Buffering&quot;
 * !* Behavior with buffering.
 * !* Behavior with buffering.

OPEN DATABASE testDBC USE testView CURSORSETPROP(&quot;Buffering&quot;, 5)

APPEND BLANK APPEND BLANK

BEGIN TRANSACTION TABLEUPDATE(1) END TRANSACTION ?RECCOUNT REQUERY  && Resets view to 0

APPEND BLANK APPEND BLANK

BEGIN TRANSACTION TABLEUPDATE(1) ?RECCOUNT END TRANSACTION ?RECCOUNT After you run the code, you expect to see the following: Without Buffering: 0        2         2 With Buffering: 2        2         2 However, in Visual FoxPro 7.0 build 9262, you receive the following results: Without Buffering: 0        2         1 With Buffering: 2        2         0 Note that without buffering, all but one of the records disappear after the END TRANSACTION command. With buffering, all of the records disappear.

Keywords: kbbug kbfix kbvfp700sp1fix kbcodesnippet kbdatabase KB319284

-

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

© Microsoft Corporation. All rights reserved.