[EMAIL PROTECTED] wrote: > Hallo, > > I've got a problem with sapdb-version 7.4.3.25 on NT. > > From a tableT I made a copy T_clone (same structure, no data) > in which I > want to insert data from T which satisfy a certain search > condition. The > insert statement looks like > > Insert into T_clone select * from T where .... > > The result is always an error: > ERR > -24988,ERR_SQL: sql error > 100,Row not found > > Executing only the select part of the whole statement gives a > dataset of > around 1500 rows. > Any advice is welcome.
Do you have some kind of trigger (an insert-trigger) for T_clone which may cause this astonishing error? In that trigger, do you check for all possible 'normal' errors like error 100 after a select, after the (last+1) fetch and perhaps return even those 'normal' errors as the trigger-result, causing the whole insert to fail? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
