Can you post your code?
>I have a fairly straight forward program that goes down throgh a mid sized SQL table and changes some of the records.
>
>After each change in SQl I issue Tableupdate() then loop back up, get more search data and the do:
>
>Locate For Alltrim(user_number)=Alltrim(Str(m.user_nbr1))
>
>After about 500 records I get Update Conflict error 1585.
>
>How do I see the error from SQL?
>
>I tried = AERROR(aErrorArray) but all I get is Update Conflict error 1585
>
>I would guess te error is the data I am putting in must conflict with some SQL rule, but how do I find out?
--sb--