RE : [development-axapta] sum

[Steeve Gilbert]

Your function stated that you have to return a real, so you can't return a record.  You function should look like this :

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

      return myTable.realField;
}

myTable.realField contains the sum.

Questions? ;-)

Steeve...

-----Message d'origine-----
De�: byteway_so [mailto:[EMAIL PROTECTED] 
Envoy�: 26 janvier 2004 10:55
��: [EMAIL PROTECTED]
Objet�: [development-axapta] sum

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/ 











Yahoo! Groups Sponsor


  ADVERTISEMENT 









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 the Yahoo! Terms of Service.