Too Many Values Specified (7531) Error

Jeevan23

New Member
Hi,
we are getting this error while we running below query in progress11 through odbc tester tool.
Error :-[DataDirect][Odbc Progress openedge wire protocal driver][openedge]Too many Values Specified (7531)
Query :

select
SUBSTRING(g."Account#",(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss where s."Seg#">=ss."Seg#" ) -s.Seg_Len)+1),s.Seg_Len) as seg
from
prdb.pub.ab_EE as g, prdb.pub.Ent as e, hrdb.pub.ab_Def as d, hrdb.pub.ab_cd_Def as s
where g.Le_Ent (+)= e.Le_En and e.ab_Id (+) =d.ab_Id and
d.ab_Id (+) =s.ab_Id

here am finding running total of seg_Len field for dividing the AccountNumber. if i replace the inner select query (below one) with any number for starting position of substring function, it is working fine.
(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss where s."Seg#">=ss."Seg#" ) -s.Seg_Len)+1)

is there any function available for finding the running_total in progress?

please suggest me.
 
Last edited:
Top