>>>I have several forms which have code similar to
>>>

x = tableupdate(.t.,.t.,'tablename')

>>>It works in VFP 7 but not in VFP 9. The form has a burffermode of 2 (optimistic buffering) and the table a buffermodeoverride of 5 (optimistic table buffering).
>>>
>>>Any one have suggestions on why this is happening and/or how to determine the problem?
>>>
>>>TIA
>>
>>And what AERROR() said?
>>

>>IF NOT tableupdate(.t.,.t.,'tablename')
>>   AERROR(laError)
>>   MessageBox(laError[1,2])
>>ENDIF
>>

>
>
>Thanks, it said "uniqness of index indexname violated". This a good clue of what is going on.
>
>The command
>

goto to bottom in tablename

The record could be deleted, but you would still have an error if the key value already exists in a table. What do you use for your index and how do you generate it?