{"id":157,"date":"2015-04-21T13:07:23","date_gmt":"2015-04-21T17:07:23","guid":{"rendered":"http:\/\/salzlechner.com\/dev\/?p=157"},"modified":"2016-03-11T07:07:22","modified_gmt":"2016-03-11T12:07:22","slug":"dataflex-overlap-fields","status":"publish","type":"post","link":"http:\/\/salzlechner.com\/dev\/2015\/04\/21\/dataflex-overlap-fields\/","title":{"rendered":"DataFlex overlap fields"},"content":{"rendered":"<p>Beginning with Visual DataFlex 17 and now even more so with DataFlex 18 functionality of overlap fields in the sql connectivity kit has been broken and will probably not be fixed by DAC.<\/p>\n<p>In any case i suggest not using overlap fields but if you have a legacy system and you are suddenly getting the following error<\/p>\n<h2 class=\"posttitle icon\">Invalid character value for cast specification<\/h2>\n<p>prepare to remove all your overlap fields.<\/p>\n<p>In VDF 17 overlap fields consisting of DATE and NUMERIC fields a were broken<\/p>\n<p>In VDF18 overlap fields consisting of multiple NUMERIC fields were broken<\/p>\n<p>The issue in VDF17 was reported to DAC and reproduced but as far as we know never fixed. The issue in DataFlex 18 has been reported<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Issues with overlap fields in DataFlex<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","ngg_post_thumbnail":0,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-157","post","type-post","status-publish","format-standard","hentry","category-dataflex"],"_links":{"self":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":2,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":279,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/posts\/157\/revisions\/279"}],"wp:attachment":[{"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/salzlechner.com\/dev\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}