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 10:35:41
 
 
To
23/05/2002 09:24:48
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00659428
Message ID:
00660455
Views:
24
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