Fortunately I have solved this problem. I think it was something about
being a two field composed foreign key and updating these two fields at
the same time gave some kind of error.
I solve it by adding a temporary row in the referenced table with one of
the fields already changed and then updatin
Posting you table difinitions and queries would be helpful.
Olexandr Melnyk,
http://omelnyk.net/
2007/2/8, Alicia Amadoz <[EMAIL PROTECTED]>:
Hello,
I am trying to update two fields of a table that are a composed foreign
key to another table. These fields cant
Hello,
I am trying to update two fields of a table that are a composed foreign
key to another table. These fields cant be updated with this kind of
warning:
Warning | 1292 | Truncated incorrect DOUBLE value: 'A05'
Both tables are InnoDB and I have tried with all types of constraints,
ON UPDATE