Re: Insert Errors - Specific Fields

[David Harper <davidh@CLIENTTECH.COM>]

Don't know an easy way to determine this Chris, other than using
display's or 'if' statements to determine which value is null.


Chris Hagen wrote:
>
>      Hello.
>
>      I have a question concerning INSERT errors and debugging them.
>
>      Presently I am inserting values in an SQR to a table with over 100
>      fields.  I am getting the following error.
>
>      __________________ERROR_________________________________________
>
>      SQL Status =-1400 SQL Error  = ORA-01400: mandatory (NOT NULL) column
>      is missing or NULL during insert
>
>      __________________END OF ERROR__________________________________
>
>      Id there any way to determine what field is producing this error or
>      any other error that may occur in the future.
>
>      Thank you for your time and consideration.

--

David Harper
ClientTech Online Solutions, Inc.
3084 Zaharias Drive
Orlando, FL  32837
407-826-8731/800-404-2560  fax: 407-888-4841