Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG?? Uniqueness of index violation - Part 2
Message
From
10/09/1997 11:24:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00049311
Message ID:
00049325
Views:
51
>>>I can easily reproduce this problem without a form.
>>>
>>>Steps to reproduce error:
>>>1) Open table with primary index and set buffering to 5 (Optimistic Table)
>>>2) APPEND BLANK
>>>3) Go to appended record and fill with valid values (unique key)
>>>4) Use up arrow to go to previous record.
>>>5) Return to new record.
>>>6) Blank out one of the fields that are part of the primary key.
>>>7) Re-enter the same value you just removed.
>>>8) Go to another record. Wham! Error!
>>>
>>>Why??? The record seems to be conflicting with itself!
>>>
>>>Elyse
>>
>>You should use TABLE BUFFERING... :)
>
>Robert -- she said that she was..
>
>Elyse -- that is new to me. is it possible that the new appended record is being treated as part of the table (set when you leave the record) and the edit in 6 & 7 is marking a buffered record (not the one in 2)?

I tried to reproduce this and got no errors. Maybe TABLEUPDATE() was fired from some 'obscured' place?
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform