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 DUBLE value: 'A05'
Both tables are InnoDB and I have tried with all types of constraints,
N UPDATE CASCADE, SET NULL and N ACTIN, as foreign key constraints of
the table that I want to update.
Any help or idea of how can I solve this problem?
Thank you very much in advance,
Alicia

Posting you table difinitions and queries would be helpful.

Melnyk,
http://omelnyk.net/

2007/2/8, Alicia Amadoz <Alicia.Amadoz (AT) uv (DOT) es>:

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 DUBLE value: 'A05'

Both tables are InnoDB and I have tried with all types of constraints,
N UPDATE CASCADE, SET NULL and N ACTIN, as foreign key constraints of
the table that I want to update.

Any help or idea of how can I solve this problem?

Thank you very much in advance,
Alicia
--