Mark Wong wrote: > I have a script to create foreign keys that is failing (ERR > -24988,ERR_SQL: sql error 350,Referential integrity violated) and I'm > trying to read a trace to determine what exactly is violated. So I'm > having trouble deciphering what the trace says when the error is > thrown. Can anyone offer some tips or a translation?
Do not try to read vtrace. For kernel developer, this is ok, but not for usual application developers. But if there are error 350,Referential integrity violated, try this: imagine you want to create a referential contraint in table treferencing (column1, column2) references treferenced (colA, colB) then do a select column1, column2 from treferencing where (column1, column2) <> ALL (select colA, colB from treferenced) (or add in the first select-list some other columns helping to find the key of those records) Then you should see those records violating the referential constraint you want to create Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
