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