Question Status

Suggested Answer
Hossain Chowdhury asked a question on 9 Feb 2015 9:40 AM

Hi,
I'm working on EP AX2012 with the table migrated from AX 4.0.
I've created a dataset from two tables(one of them is tmp table).
When adding the dataset to a axGridView, I'm getting the error above.
These two tables has been migrated from AX 4.0.
I checked the join, relations of individual tables. All looks fine.

I'm guessing it could be something to do with AX2012 table properties.

Any ideas to find issue step by step.

Regards,

Hossain

Reply
Suggested Answer
Iulian Cordobin responded on 9 Feb 2015 1:35 PM

One thing you can look for is the DataKeyName property you have for the AxGrid in the web control (in VS, if you open up the web control page definition (.ascx)). You should have fields that form the unique key from both tables.

Another thing is the PK on the temp table, it has to be set to RecId and you need to use it in the DataKeyName.

Reply
Iulian Cordobin responded on 9 Feb 2015 1:36 PM

Forgot to ask, the tables in the dataset are inner joined, right?

Reply
Hossain Chowdhury responded on 11 Feb 2015 6:05 AM

Hi Iulian,

The join is active.

This is fine now.

Thanks,

Hossain

Reply
Iulian Cordobin responded on 11 Feb 2015 6:20 AM

Can you describe here what exactly you did in order to solve your issue? It might help others in the future.

Reply
Hossain Chowdhury responded on 2 Mar 2015 4:58 AM

Hi Iulain,

I removed one of the a table from the Datasource.

And I noticed that the table with array field was the issue.

I need to add the table again. But having issue with that.

So, the solution wasn't the very complete one.

Regards,

Hossain

Reply
Suggested Answer
Iulian Cordobin responded on 9 Feb 2015 1:35 PM

One thing you can look for is the DataKeyName property you have for the AxGrid in the web control (in VS, if you open up the web control page definition (.ascx)). You should have fields that form the unique key from both tables.

Another thing is the PK on the temp table, it has to be set to RecId and you need to use it in the DataKeyName.

Reply