Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behavior with a cursor
Message
From
30/07/2010 18:59:03
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01474694
Message ID:
01474695
Views:
102
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>I have a form with a grid. In the DE of this form I select records into the cursor from SQL Server using SQLExec. I then do
>select * from csrResponses into csrResponses readwrite to make sure my cursor is read write.
>
>Now the fun begins. Near this grid I have Add, Edit, Delete buttons. I delete some records with delete command, they disappear just fine. (Form's deleted status is set to ON) I then Add a new record with Append BLANK , replace ... and all deleted records re-appear!!!
>
>Is it a bug in VFP? I'm going to try with Insert Into then, but the behavior is very strange.
>
>Thanks in advance.
>
>So, the question is - is it OK to delete and add new records to cursor without re-appearing of the records?
>
>UPDATE.Insert command didn't fix this behavior.
>
>See the initial grid, then grid with deleted records, then grid with record added.

set a break point on set("deleted") and see if something is turning it on...
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform