Hallo,
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!
What is wrong?
Thanks for your help!
mfg
Ines Liefeldt
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
