Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting records to non modified in a table buffered view
Message
De
23/05/2002 11:03:36
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
23/05/2002 10:35:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00659428
Message ID:
00660503
Vues:
34
Hi Oscar

My suggestion should still work. By the way, are you using a grid for navigating the records and then editting one of these records? You may find performance is much better if you use one view for the grid and a different view for the data entry.

>Hi mMike thanks for your reply.
>
>I added a check through GetFldState and it seems to be working now, the problen is that the method checking for changed fields is part of a framework. I had to everride te method.
>
>
>Regards
>
>
>Oscar Corte
>
>
>>Hi Oscar
>>
>>Why not just ...
>>
>>LOCAL llSendUpdates
>>llSendUpdates = CURSORGETPROP("SendUpdates")
>>CURSORSETPROP("SendUpdates",.F.)
>>TABLEUPDATE()
>>CURSORSETPROP("SendUpdates",m.llSendUpdates)
>>
>>In other words, prevent VFP from committing changes, do a tableupdate and then allow VFP to resume committing changes?
>>
>>>I’m using a local view with BufferModeOverride = 5 (Table Optimistic)
>>>
>>>After performing a requery, I set a couple of non updatable fields to values needed to show in a grid.
>>>
>>>
>>>I need to set the cursor to a non modified state, but I haven’t been able to get it.
>>>
>>>I’m issuing SetFldState(,”Cursor”, 1) and everything seems to be set properly to a string of 1’s
>>>
>>>The problem is that the GetNextModified function somehow still detects those records as modified.
>>>
>>>Is there a way to set the fields or records to non modified and not have the function GetNextModified not to detect them?
>>>
>>>Thanks in advance
>>>
>>>
>>>Oscar Corte
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform