hello. Imran is right.
I would add additional information about enquiry routine. I think you create conversation enquiry routine. You must use INSERT command in your routine: $INSERT I_ENQUIRY.COMMON Last extracted value can be obtained from a common variable O.DATA Current record can be obtained from a common variable R.RECORD. R.RECORD - static array. Put the result of work to O.DATA variable, for transfer it to enquiry. On 21 май, 18:36, gabalian <[email protected]> wrote: > Hi, > > You can use DCOUNT to count the number of multivalued opened of a > particular multivalued field. > for example TOT.VAL = DCOUNT(TURNOVER.DEBIT,VM) will give u the total > numbers of multivalued opened for the field TURNOVER>DEBIT. > You can also use SUM(TURNOVER.DEBIT) to get the sum of all the values in all > opened multivalued fields of TURNOVER.DEBIT > > Regards, > Imran > > On Wed, May 20, 2009 at 8:50 PM, [email protected] <[email protected]>wrote: > > > > > > > hello > > im working on a report and would need a routine to loop through a set > > of multi value fields, count and add up the fields and store the > > values in a dynamic array. say for example i need to add up the > > TURNOVER.DEBIT values for a month based on an ID in the table > > ACCT.ACTIVITY > > i am relatively new to jbase and would need some ideas on how to go > > about it. > > > thanx in advance > > > Paul > > -- > Imran Khan > T24 Technical Consultant+92 334 3545114 --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
