Re: Question about insert failed.

At 20:23 -0700 6/11/03, T R O D A T wrote: Hello all, In version 3.23.X we had a script running: 1 - Create a temp table from imported cdf files. 2 - Select into the production table using criteria. 3 - Use production table. -- On a duplicate record, for some reason our Oracle folks think this is

Question about insert failed.

Hello all, In version 3.23.X we had a script running: 1 - Create a temp table from imported cdf files. 2 - Select into the production table using criteria. 3 - Use production table. -- On a duplicate record, for some reason our Oracle folks think this is acceptable, the duplicate record was ign

Re: Insert failed

Looks like someone entered a negative number for EventId, or it just reached its maximum value. Check its maximum and minimum values. Change it to an unsigned int. Xavier NOPRE wrote: >Hi, > >I try to insert a new record in a table. The key is an automatic ID. >The insert is refused due to du

Insert failed

Hi, I try to insert a new record in a table. The key is an automatic ID. The insert is refused due to duplicate key, but the key does not exist. Why ? Is it a bug ? Any idea ? Some help ? Thanks Xavier Details: The colums of the table: ++--+--+-+-