Ines Liefeldt wrote: > I have a problem with a statement like > > update dba.n_Stellen > set vze_anspruch=vze_anspruch+:vze > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > It breaks with error -2010: Assignment impossible, char > value too long. > > The values are: > - c_verguet(int)=6 > - c_beg(date)='2002-01-01' > - c_end(date)='2002-08-01' > - sanr(int)=3 > - vze(float(38))=2.9285714285479964285714286000000000000E-02 > - vze_anspruch(float(38))=48.4517032971988 /52.4129120884674 > /49.4517032972108 / ... or so, but not null > > btw: the statement > > update dba.n_Stellen > set vze_anspruch=vze_anspruch+fixed(:vze,8,2) > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > breaks with the same error message, but > > set vze=fixed(vze,8,2); > update dba.n_Stellen > set vze_anspruch=vze_anspruch+:vze > where deckring_sl in > (select deckring_sl from DBA.n_deckring > where verguet_sl=:c_verguet and not ueberlauf) > and akt_datum>=:c_beg and akt_datum<=:c_end > AND SCHULAMT_NR=:SANR > > works without error!
Sorry for the late response but I missed your mail somehow. Could you please provide all information to reproduce the problem. Especially the table definition of n_Stellen and n_deckring. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
