Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupted record may is added to the view
Message
From
19/12/2005 11:38:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01078688
Message ID:
01079206
Views:
23
Sergey, my form is parent-child form, and the method to insert one item in child table (I am using local view) is
INSERT INTO vwitemroman (nrromaneio) VALUES (romaneio.nrromaneio)
Thisform.grdItemroman.Column1.txtcdprodutoreadwrite.Setfocus()
Thisform.grdItemroman.Setfocus()

If I insert a few itens the corrupted record does not appear, but after 40 itens when I confirm tableupdate for all tables one corrupted record is inserted on child table.

The view is buffermodeoverride = 5

>How do you know that it's the same problem? Do you have code to repro it?
>
>>I have a problem that is registered on MS VFP KB. The KB article is: A corrupted record may be added to the view if you set focus to the grid every time that a record is added in Visual FoxPro for Windows 3.0 and in Visual FoxPro for Windows 5.0 - Article ID : 195405
>>
>>The KB article says that this bug is corrected in VFP 6. I am using VFP 9 and the problem continues.
>>
>>Does anybody know how to by pass the problem. I need to set the focus in the grid after each insert.
Antonio Carlos Kleinübing
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform