Hi Mike,

>>You may have to go through and eliminate fields until the problem goes away...then that is your troubled field.
>
>here is what i'm trying to do. but i'm getting errors on loCommand.ActiveConnection.Errors.Item(0).Description...
>I have tried ...item(1) and item(0) neither works...
>

you may have to get the object reference first. ie:

TRY
	loCommand.Execute    
CATCH TO staterr
  lExecuteErr = 1	
 
  FOR EACH loError IN loCommand.ActiveConnection.Errors
    lExecuteErrMsg = lExecuteErrMsg  + loError.Description+ g_crlf
    lExecuteErrMsg = lExecuteErrMsg  + TRANSFORM(loError.Number)+ g_crlf
    lExecuteErrMsg = lExecuteErrMsg  + loError.Source+ g_crlf
    lExecuteErrMsg = lExecuteErrMsg  + TRANSFORM(loError.SQLState)+ g_crlf
  ENDFOR
ENDTRY

but ultimately you will probably have to remove fields/parameters from the UPDATE command until it works. Try the divide and conquer method...130 fields should only take 8 tries.