Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 299849 - Last Review: May 12, 2003 - Revision: 2.1
FIX: Failed TABLEUPDATE Places Record Pointer on Nonexistent Record
This article was previously published under Q299849
When you run multiple instances of Visual FoxPro (VFP) and a
TABLEUPDATE fails, the record pointer is on a nonexistent record.
This problem was corrected in Visual FoxPro version 7.0 for Windows.
Steps to Reproduce Problem
- Paste the following code in a new program in VFP version 3.0, 5.0, or 6.0.
*!* Q299849 FIX: Failed TABLEUPDATE Places Record Pointer On Nonexistent Record
CLEAR
SET EXCLUSIVE OFF
SET SAFETY OFF
SET MULTILOCKS ON
CREATE Table Demo74 ( cTest C(10))
INDEX ON cTest TAG cTest CANDIDATE
USE
=MESSAGEBOX('Start Part One')
USE Demo74
=CursorSetProp("Buffering", 5)
FOR lnI = 1 TO 10
APPEND BLANK
REPLACE cTest WITH Sys(2015)
ENDFOR
APPEND BLANK
REPLACE cTest WITH '12345'
=MESSAGEBOX('Start Part Two')
? 'Reccount(), Recno() ', Reccount(), Recno()
? 'GetFldState(-1) ', GetFldState(-1)
* Comment out the next line if running in VFP 3.
? 'TableUpdate(1, .t.) ', TableUpdate(1, .t.)
*Uncomment the next line if running in VFP 3.
* ? 'TableUpdate(1, .t.) ', TableUpdate(.t., .t.)
? 'Reccount(), Recno() ', Reccount(), Recno()
? 'GetFldState(-1) ', GetFldState(-1)
? 'Eof() ', Eof()
*Uncomment the next line if running in VFP 3.
* =TableRevert(.t.)
USE
- Save and run the code (the name is unimportant).
- Start another instance of VFP and run the same code.
- Switch to the first instance of VFP and click Start Part One.
- Switch to the second instance of VFP and click Start Part One.
- Switch to the first instance and click Start Part Two.
- Switch to the second instance and click Start Part Two.
The record pointer in the second instance is on a record that does not exist in the table.
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
| kbbug kbcodesnippet kbdatabase kbfix kbvfp700fix KB299849 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please