Microsoft Dynamics AX (Archived)

Getting data from a field that might not exist

(0) Share

Report

Posted on by Community Member

I have created a method that reads data from a table.

However, all of our customers might not have one of the fields that are read in this method. Nevermind why :-)

So I want to make sure that this method will still compile and run in all systems.

So...how can I check if the field exists in the table and how can I read the data from the field if it exists?

Thanks!

/Jonas

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

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

Like (0)

Report
I recommend to adjust an application architecture (layers, configuration keys or so), because that it a real source of problems.

Anyway, the easiest code-based solution is probably this one:

fieldId = fieldName2Id(buffer.TableId, 'FieldName');
if (fieldId) { value = buffer.(fieldId); }

You lose, of course, all compilation-time checks, cross references etc.

Another solution would be to use preprocessor macros to achieve a conditional compilation, but I strongly recommend to avoid it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Martin.

Just as a quick response, the reason I need this is that the new field is part of a large update that cannot be performed right now, but this new method needs to be deployed immediately and I did not want to comment out a certain line for just one customer, since that would probably cause even more trouble if I forget to add it again :-)

Was this reply helpful? Yes No
Denis Patrakov on at

Like (0)

Report

You can deploy this new method with the new field to all your customers right now - just set the field's SaveContents property to No (and maybe Visible to No, too) so that it doesn't appear in the database after synchronization - if this is what you are concerned about. Your large update then would change SaveContents to Yes for this field. Although a new configuration key would be a better solution.

Was this reply helpful? Yes No