How to insert Multi select values in detail transaction form

(0) Share

Report

Posted on by Laraib

131

I have created Detail Transaction Form. In which I have added multi select lookup but issue is when i open lookup or press ok button of lookup Dynamics Ax 2012 forcedly close.

I am aware of Detail Transaction Form's grid behavior that it by default insert record in table but what I want is that grid create numbers of record in table according to the number of selected value of multi select lookup.

Here is the lookup code below:

public void lookup()
{
	Query query = new Query();
    QueryBuildDataSource queryBuildDataSource;
    QueryBuildRange queryBuildRange;
    SysTableLookup sysTableLookup;
    str ItemCategoryCodeforlockup = RNI_SchemeLinesDetailTable_Product.valueStr();

    sysTableLookup = SysTableLookup::newParameters(tableNum(SL_ItemCatSubType), this);
    queryBuildDataSource = query.addDataSource(tableNum(SL_ItemCatSubType));
    queryBuildDataSource.addRange(fieldNum(SL_ItemCatSubType,RNI_LINEOFPRODDESCRIPTION)).value(ItemCategoryCodeforlockup);

    sysTableLookup.parmQuery(query);
    sysTableLookup.addLookupField(fieldNum(SL_ItemCatSubType, Description));
    sysTableLookup.addLookupField(fieldNum(SL_ItemCatSubType, Itemcategorycode));
    sysTableLookup.performFormLookup();

    msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this.formRun(),this,query);  
}

public boolean modified()
{
	boolean ret;

	container c,v;
	int i;
	ret = super();
	
	if (ret)
	{
		c = msCtrl.get();  // get RecIds of the selected rows
		v = msCtrl.getSelectedFieldValues(); // get actual value of the selected rows

		for (i = 1; i <= conLen(c);i  )
		{
			//info(conPeek(c,i));
			//info(conPeek(v,i));
		}
	}

	return ret;
}

Below is the error screen shots

multiselect

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report

Try debugging yourr code and finding at which line it crashes.

Was this reply helpful? Yes No
Laraib 131 on at

Like (0)

Report

Thanks for guiding.

I have debugged code but when I select lookup value it crashes without going to code

Was this reply helpful? Yes No
Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report

I think I see the bug. You're trying to create two lookups at once - one with SysTableLookup and another with SysLookupMultiSelectCtrl.

Was this reply helpful? Yes No
Laraib 131 on at

Like (0)

Report

I have comment SysTableLookup but it giving same error

Was this reply helpful? Yes No
Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report

Please show us your new code and tell us the type of control whose lookup() control you've overriden.

Also, I hope tnat you aren't trying to store multiple values in a single table field, because that would be a very bad idea.

Was this reply helpful? Yes No
Laraib 131 on at

Like (0)

Report

Yes Martin, I am trying to insert multiple values in single table. Its client requirement

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report
You can have mutliple values in a single table - simply create a mutliple rows.

But if you want to insert multiple comma-separated values to a single table field, then it's a bug. Note that end users are not software architects and you can't expect from them to do now how to do it. It's your job to find a meaningful technical solution for their business requirements.

Putting multiple values to the same field would be so big flaw that it's forbidden already by the first normal form of database design. It has many problems. For example:

You can't meaningfully query the field. For example, you can't find if the fields contains an element called "abc". All you can do is checking if it contains such a string, but it's slow and it may return different data that you wants.

You can't index the content, therefore finding values will end up with full-table scans.

You can't set a meaningful lenght of the field.

The right approach is different. Create a new table related to the main one and create a row there for each value. For example, instead of having "A,B,C" in a single field, you'll have three rows in a table. In your case, you'll store a reference to the main table and an ID from SL_ItemCatSubType table.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to insert Multi select values in detail transaction form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to insert Multi select values in detail transaction form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates