Hi all,
I have a main table with a PK KeyName TEXT 4
and a secondary table with a FK (same name and same definition) that
reference KeyName.
The code is alphanumeric and have been entered in lower cases.
When I try to retype the PK in Uppercase, I get the constraint message
saying that the PK value can't be changed because it is referenced in an
other table.
As CASE is set to OFF, I don't understand why ...
Same with :
UPDATE MainTableName SET KeyName = (LUC(Keyname)) WHERE KeyName =
'KeyValue'
I find this feature much more strict than it should be ....
And also unlogical, because :
UPDATE SecondaryTableName SET KeyName = (LUC(Keyname)) WHERE KeyName =
'KeyValue'
works fine ... but :
UPDATE MainTableName SET KeyName = (LUC(Keyname)) WHERE KeyName =
'KeyValue'
still don't work, and without any reason ...
Is there a way to turn that off (without deleting the constraint of course)
?
TIA
J.M. GRATIAS, Logimatique, France
