I still have troubles with the folowing:

> I have one problem. Here is exactly what I put in dataset:
>
> INSERT INTO MATCONTI (MC_MAT_KEY, MC_MAT_KC, MC_QTY)
> SELECT 'new_key', M2.MC_MAT_KC, M2.MC_QTY
> FROM MATCONTI M2
> WHERE M2.MC_MAT_KEY = 'old_key'
>
> After ExecSQL I get an error message:
>
> Violation of PRIMARY or UNIQUE KEY constraints "INTEG_94" on table
> "MATCONTI"

Maybe I should tell before, that both MC_MAT_KEY and MC_MAT_KC are primary
keys.

What should I change to get it work properly ?


Regards,
Primoz