Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requiry() and uncommitted changed error
Message
 
To
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:
01260365
Views:
22
>>>>>
>>>>>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)


Agree,
but usually (not all the times though) when you do not change anything in the forms and have Uncommitted changes error you often change them somewhere in your program, so it would happens for all records, not just for the current one.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform