>So are you using Parameter objects? Or are you building your UPDATE statement from scratch? Or is this a SP call?
it is an update using parameter objects
>Is it possible you are passing a NULL value to a field that does not allow NULLs?
yes, but not sure which field
>If you are using Parameters objects, could one of your field values be transposed from a numeric field to a character value...or visa versa?
yes, but how can I determine which field?
>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...
*------------------------------------------------------------
*-- Execute
*------------------------------------------------------------
lExecuteErr = 0
lExecuteErrMsg = []
TRY
loCommand.Execute
CATCH TO staterr
lExecuteErr = 1
lExecuteErrMsg = lExecuteErrMsg + loCommand.ActiveConnection.Errors.Item(0).Description+ g_crlf
lExecuteErrMsg = lExecuteErrMsg + loCommand.ActiveConnection.Errors.Item(0).Number+ g_crlf
lExecuteErrMsg = lExecuteErrMsg + loCommand.ActiveConnection.Errors.Item(0).Source+ g_crlf
lExecuteErrMsg = lExecuteErrMsg + loCommand.ActiveConnection.Errors.Item(0).SQLState+ g_crlf
ENDTRY
IF lExecuteErr = 1
=MESSAGEBOX(lExecuteErrMsg,16,'loCommand.Execute')
CLEAR EVENTS
exit
ENDIF