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 Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question
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/
RE : RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question
Just tried the job and... I have no answer for you. I don't understand why it behave like that. Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 11:39 À : [EMAIL PROTECTED] Objet : Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question 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 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/