Re: Having problem to sum the columns

I haven't used OWS. Are there null values in your newly added column? This can cause wrong results. -- Meyer

Kashif Ahmed wrote:

> Dear
>
> I am working on OWS and making a procedure to print the table on the
> web. Every thing work fine when I just print the ewhole table by using
> owa_util.tablePrint command. But when I try to add one more column as
> a sum of all column , It gives me error while it sums only six (6)
> column fine, as I add one more column to sum, It gives error.
>
> The Red one is the columns what I wanted to add from fld0 to fld11.
> It works on fld0 to fld5.
> Please tell me why it is causing the problem and how do I solved it,
> ASAP.
>
> manswer:=
> owa_util.tablePrint('cyb_session_t','BORDER=1', 1,
> 'cyb_date_converter(created_t), plan, fld0, fld1, fld2, fld3,
> fld4, fld5, fld6, fld7, fld8, fld9, fld10, fld11,
> fld0+fld1+fld2+fld3+fld4+fld5' ,
> 'WHERE created_t > ' || SDATENUM || ' and created_t < ' ||
> EDATENUM,
> 'Date, Package Name, Hr 00, Hr 01, Hr 02, Hr 03, Hr 04, Hr 05,
> Hr 06, Hr 07, Hr 08, Hr 09, Hr 10, Hr 11, Total' );
>
>
> I hope to hear from you soon.
> Best Regards
> Kashif Ahmed
>
Received on Sat Jun 24 2000 - 00:00:00 CEST