Yes - My key expression field is a characture format. lcKeyType does return a N on "10056" where it should be a C. No - it does not log any changes - it dies before the SQL update code.

Jeff

>>I didn't have the index set to primary - so i changed it and now it is working (to a point).
>>
>>New Problem:
>>
>>When the program tries to set LcKey it had evaluated it as numeric, yet it is a characture field.
>>
>>LcKey = ALLTRIM(STR(luKey))
>>
>>luKey = "10056"
>
>You lost me... the procedure converts whatever datatype your key is into Character so that it can be stored in the Memo field.
>
>Are you saying, lcKeyType is a 'N' when it should be an 'C' ???
>
>So, you primary key expression is Character? Does it log the changes, or do you still get an error?
>
>BOb