|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
problems with Fks
IŽam making foreign keys in my DB. Everything is working fine at first buy
now IŽam having problems in the generation of this FK. In some tables I wan`t to make some FKs to diferents tables. But I can only make the first FK. Whe I wanŽt to make the second I have this error from IBExpert. I have changed the orders to make the FK and i can make ever the first one, but in the second I have the same error. I have thist problem in some tables only. In others I can make the FK i want. I`am really lost with thist. ---------- STATEMENT ---------- alter table MOVIMIENTOS_CAJA_OPERADOR add constraint FK_MOVIMIENTOS_CAJA_OPERADO foreign key (MOVIMIENTO) references MOVIMIENTO(CODIGO) ---------- ERROR MESSAGE ---------- This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$INDICES failed. attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_5". |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > problems with Fks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|