Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange behavior with a cursor
Message
De
30/07/2010 18:59:03
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01474694
Message ID:
01474695
Vues:
103
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"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform