Dear Steeve,
See my previous message on the unbalance ttsbegin/ttscommit. That is the job. Have a look at it. When I run it I am only see one record in the list that pops up when I open the field criteria. regards, Danny --- In [EMAIL PROTECTED], "Steeve Gilbert" <[EMAIL PROTECTED]> wrote: > Can you send your job here? > > Steeve... > > > -----Message d'origine----- > De : Danny Gaethofs [mailto:[EMAIL PROTECTED] > Envoyé : 6 décembre 2004 09:14 > À : [EMAIL PROTECTED] > Objet : Re: RE : [Axapta-Knowledge-Village] QueryBuildRange question > > > > it is just a job I am running > > > --- In [EMAIL PROTECTED], "Steeve Gilbert" > <[EMAIL PROTECTED]> wrote: > > There's not link between fields in indexes and range not being > there. Try pressing "Reset" when you see the range columns. In > what method did you add your range? > > > > Steeve... > > > > > > -----Message d'origine----- > > De : Danny Gaethofs [mailto:[EMAIL PROTECTED] > > Envoyé : 6 décembre 2004 06:23 > > À : [EMAIL PROTECTED] > > Objet : [Axapta-Knowledge-Village] QueryBuildRange question > > > > > > > > Dear all, > > > > I added a QueryBuildRange to my query. I expected that when > opening > > the Criteria column I would see all the unique values available in > > my table but I do not. > > > > I believe I understand the reason, but while I am not sure, I just > > want to have some input of you. I think it is because I am not > using > > a field that is indexed. It happens I am using a field that is > part > > of an index. > > > > > > This is the QueryBuildRange I added to my query: > > qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, > > AddrTableID)); > > > > The field AddrTableId is part of the index AddreIdx, which > contains > > the fields AddrRecId and LineNum. > > > > How can I get the full list of available values shown in the > column > > criteria? > > > > regards, > > Danny > > > > > > > > > > > > > > Sharing the knowledge on Axapta. > > Yahoo! Groups Links > > > > > > > Sharing the knowledge on Axapta. > Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/