RE : RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Steeve Gilbert

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/
 





Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question

2004-12-06 Thread Danny Gaethofs


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/