Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requiry() and uncommitted changed error
Message
From
11/10/2007 13:36:31
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01260229
Message ID:
01260361
Views:
15
>>>>
>>>>Please, just to clarify, you are saying that a value in the cursor view (MyView) is being changed? And not the value of the table field corresponding to the view field, correct?
>>>
>>>Yes, you have changes in your View, not in the underlaying Table.
>>>
>>>>
>>>>The reason I am asking is that recently this customer developed his own program (I am not ever sure he used VFP - I think he used Java) and his program adds records to the table on which my view (MyView) is based. So I was wondering if it is possible that by him adding or changing values in the VFP table it could affect the =requery() of my view.
>>>
>>>If somebody changes your table before you run TABLEUPDATE() you will get different error. TABLEUPDATE() will return .f. and AERROR() will return that there are collisions, of course if you didn't force the TABLEUPDATE(1, .t.,...)
>>
>>Thank you very much, Borislav.
>
>Welcome :-)

Just a small additional thing to consider: If you have tablebuffering set to 5, then you should use getnextmodified(0) to find out if some other row than the one the pointer is currently sitting at may have changed. You can then position the pointer at the changed record and use GetFldState() to see what exactly changed. Then use GetNextModified(RECNO()+1) to see if there are other rows with changes as well.

I use the following simple expression to see if there are any kinds of changes in a given row:

llSomethingChanged = REPLICATE('1', 256) != GetFldState(-1)

(assuming SET EXACT = OFF)
Pertti Karjalainen
Product Manager
Northern Lights Software
Fairfax, CA USA
www.northernlightssoftware.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform