![\"\"](\"https:\/\/www.bakke.online\/wp-content\/uploads\/2017\/04\/wrongtype.png\")
<\/p>\n
Error executing code: Wrong argument types in variable assignment.<\/p><\/blockquote>\n
Using SqlDataReader.GetDataTypeName() to check the data type, it shows DateTime2. \u00a0The destination field is a datetime field, but this problem as well as the solution happens even for plain date fields.<\/p>\n
So, we might try to use SqlDataReader.GetDateTime() instead, but that results in exactly the same error.<\/p>\n
<\/p>\n
The problem is happening because what is returned by the get_Item() and GetDateTime() is actually a CLR object, not a native X++ object. \u00a0As is documented for the CLR Interop layer in AX, AX can’t chain operations on CLR objects, and what is happening above is actually an implicit conversion feeding into an assignment operation.<\/p>\n
To work around this, we need to stuff the return value from get_Item() into a local variable, and then assign that variable into the record field instead. \u00a0This is called a bounce variable.<\/p>\n
utcDateTime<\/span> <\/strong>dateTimeTmp;\n\n...\n\ndateTimeTmp = reader.get_Item( \"REGISTRATIONDATE\"<\/span> );\nblocks.Field1 = dateTimeTmp;<\/pre>\nA bit non-intuitive, because we’re still dealing with an implicit conversion feeding into an assignment operation, it just happens to work with a local variable.<\/p>\n
This same problem is also happening for decimal\/numeric fields and int-values to be loaded into an enum field. \u00a0Again, the solution is the same: Create a local bounce for the value.<\/p>\n","protected":false},"excerpt":{"rendered":"
In Dynamics AX, you can use ADO.NET to retrieve data from external data sources. \u00a0This is quite easy to do for text and numeric data types, but not for Date or DateTime data types. If you try a simple assign, you’ll end up throwing an exception: blocks.Field1 = reader.get_Item( “REGISTRATIONDATE” ); Error executing code: Wrong … Continue reading “Retrieving date\/datetime from ADO.NET into a record field”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[2,3,6],"class_list":["post-103","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax","category-uncategorized","tag-ax2012r3","tag-dynamics-ax","tag-error-messages"],"_links":{"self":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":0,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bakke.online\/index.php\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}