Hi,
Thanks for replying, I got more specific from your code :)
On Wed, Jul 7, 2010 at 9:07 PM, mgk915 <mae...@alrinach.net> wrote:
>
>
>
> See if this helps:
>
> <textarea rows=15 cols=60 name="fmstCONTENT_TEXT"
> >//THIS EXAMPLE SHOWS RANGES NO MATTER WHAT updated
> 6/11/2010 10:25 AM
> //DATA-SOURCE TABEL THEY ARE SPECIFIED ON:
>
> display str shoAllRanges()
> {
> // MGK 6-11-2010
> // pickup report ranges with descritptions;
>
> int ix, iqds;
> str 160 sShowRanges;
> str 20 rangeName;
> str 60 rangeValue;
> QueryBuildDataSource qds;
>
> ;
>
> sShowRanges=" ";
> for (iqds = 1; iqds<= element.query().dataSourceCount(); iqds++ )
> {
> qds = element.Query().dataSourceNo(iqds);
>
> for (ix = 1 ;ix<=qds.rangeCount(); ix++)
> {
> rangeName = qds.range(ix).name(); //
> rangeValue = any2str(qds.range(ix).value());
>
> if (substr(qds.range(ix).label(),1,8)!="noBlanks")
>
> {
> if (strScan(rangeName,"Country",1,10)>0) {
> sShowRanges = sShowRanges + " Country: ";
> }
> else if (strScan(rangeName,"State",1,20)>0) {
> sShowRanges = sShowRanges + " States: ";
> }
> else if (strScan(rangeName,"Date",1,20)>0) {
> sShowRanges = sShowRanges + " Dates: ";
> }
> else if (strScan(rangeName,"Dimension",1,20)>0) {
> if (strScan(rangeName,"[1]",1,20)>0) {
> sShowRanges = sShowRanges + " Department: "; }
> if (strScan(rangeName,"[2]",1,20)>0) {
> sShowRanges = sShowRanges + " CostCenter: "; }
> }
> else { // if user added a range:
> sShowRanges = sShowRanges + " " + rangeName + ": ";
> }
>
> if (rangeValue<=' ') { rangeValue = 'All '; }
>
> sShowRanges = sShowRanges + rangeValue;
> } // if not blanks
> } // end for all the datasource query ranges found
> } // end for all the datasources found.
> return sShowRanges;
> }
>
> </textarea>
>
> --- In
> Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>,
> "thomas 'znal' ramdhan"
>
> <thomasramd...@...> wrote:
> >
> > Dear all,
> >
> > I'd like to ask a question about findRange in queryBuildDataSource.
> For
> > illustration, I have a form and I define a range. I'd like to get the
> range
> > value in that form. I'm using
> > queryBuildDataSource.findRange(fieldnum(xtsWRKRmTrfHeader, RefId)),
> but the
> > result return null.
> >
> > Does anyone know how I get the range in a form ?
> >
> > Thanks and Regards,
> > Afin
> >
> > --
> > ne faites pas une limite pour votre competence
> >
> ----------------------------------------------------------\
> -
> > bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
> >
> ----------------------------------------------------------\
> -
> > non faccia un limite per la vostra abilita
> >
> ----------------------------------------------------------\
> -
> > --(-@
> >
>
>
>
--
ne faites pas une limite pour votre competence
-------------------------------------------------------------------------
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-------------------------------------------------------------------------
non faccia un limite per la vostra abilita
-------------------------------------------------------------------------
--(-@
