Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting records to non modified in a table buffered view
Message
From
23/05/2002 11:03:36
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
23/05/2002 10:35:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00659428
Message ID:
00660503
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform