result of select command into combox in ax

Latest Axapta / Dynamics AX FAQ Pages

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Not Verified) This post has 0 verified solutions | 8 Replies | 3 Followers

Male
146 Posts
1,864 Points
Joined: 2012-7-24
Last Online:
2014-8-30 10:03
Location: Esfahan Iran
jalal Montazeri posted on 2012-12-5 11:11

hi all,

I have a combo box and i want to write a select command and fill data to combo box

please guidance me

thanks

All Replies

Male
3,233 Posts
78,704 Points
Joined: 2007-11-12
Last Online:
2014-12-9 16:28
Location: Hyderabad - India
DynamicsAXMVP
Kranthi replied on 2012-12-5 11:27

Please elaborate your requirement

 

 

Kranthi

298 Posts
4,338 Points
Joined: 2011-7-29
Last Online:
2014-6-26 13:42
Location: Banglore, India
EnriqueKevin06 replied on 2012-12-5 11:52

Hi,

 

  Kindly give the detailed info .. Here is one example with what i have understood on ur query.

 

 

  Select forupdate yourtable where ( give the req condition);

yourtable.combofield = yourtableenumtyp::selection;

yourtable.update();

Thats al....

 

Thanks and regrads,

Kevin

Male
264 Posts
2,340 Points
Joined: 2005-3-23
Last Online:
2012-12-17 0:03
Location: Copenhagen, Denmark
Solution (Not Verified) Kashperuk Ivan replied on 2012-12-5 14:28
Suggested by Kashperuk Ivan

Why do you specifically want it to be a combo box and not a standard lookup?

SysTableLookup class could display something based on a query

Global::pickList() is an example of showing a list of elements in a different way, which can give you another perspective.

Male
146 Posts
1,864 Points
Joined: 2012-7-24
Last Online:
2014-8-30 10:03
Location: Esfahan Iran
jalal Montazeri replied on 2012-12-6 12:39

THANKS ALL,

i want to click button and filter combobox automatically

for example with click just select number  assement_id==2

 

Male
146 Posts
1,864 Points
Joined: 2012-7-24
Last Online:
2014-8-30 10:03
Location: Esfahan Iran
jalal Montazeri replied on 2012-12-6 12:41

THANKS ALL,

i want to click button and filter combobox automatically

for example with click just select number  assem

 

 

Male
264 Posts
2,340 Points
Joined: 2005-3-23
Last Online:
2012-12-17 0:03
Location: Copenhagen, Denmark
Kashperuk Ivan replied on 2012-12-6 13:43

Then it's not really a combo box in AX terms. just a normal lookup

and that's why you should look for example of using SysTableLookup class

Male
146 Posts
1,864 Points
Joined: 2012-7-24
Last Online:
2014-8-30 10:03
Location: Esfahan Iran
jalal Montazeri replied on 2012-12-8 10:49

hi kashpeuk

thanks for guidance

i have two sys table lookup i want when a lookup change text other lookup filter whit selected lookup value

like this :

Male
366 Posts
8,130 Points
Joined: 2010-8-23
Last Online:
2014-11-26 17:54
Location: Bangalore,India
Suggested by vinothkumar

Hello JM,

In the second lookup method, pass the value of the first control value in the queryBuildRange.So it filters the records based on the first control.
let say, in the 2nd control of the lookup method
qbr.value('Pass the first control<Assement_id>).

Page 1 of 1 (9 items) | Get this RSS feed | Bookmark and Share