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?