As you need to return a real not a record.

> static real MyTotal(Date _dd, Code _cc)
> {
>     MyTable myTable;
>     ;
>
>     return
>        (select sum (realfield)
>        from myTable
>        where myTable.Date == _dd
>        && myTable.Code == _cc).realfield;
> }

/Jesper


-------- Original Message --------
Subject: [development-axapta] sum (26-Jan-2004 16:57)
From:    [EMAIL PROTECTED]
To:      [EMAIL PROTECTED]

> Hi all,
>
> A question on how to use simple database functions ;-)
> Suppose I have the next new static function:
>
> static real MyTotal(Date _dd, Code _cc)
> {
>     MyTable myTable;
>     ;
>
>     return
>        select sum (realfield)
>        from myTable
>        where myTable.Date == _dd
>        && myTable.Code == _cc;
> }
>
> How do I get the retrieved value?
>
>

>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
>
> To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
>
>
> To: [EMAIL PROTECTED]


Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to