{"id":286,"date":"2012-07-26T09:40:20","date_gmt":"2012-07-26T09:40:20","guid":{"rendered":"http:\/\/foxware.co.uk\/?p=286"},"modified":"2012-07-26T09:40:20","modified_gmt":"2012-07-26T09:40:20","slug":"ax-bc-query-with-joins","status":"publish","type":"post","link":"http:\/\/foxware.co.uk\/?p=286","title":{"rendered":"AX BC- Query with Joins"},"content":{"rendered":"<pre class=\"lang:c# decode:true\" >\r\n\r\n\r\ntry\r\n{\r\n    AxaptaRecord[] tableArray = new AxaptaRecord[2];\r\n    AxaptaRecord APMObjectTableRecord = DynAx.CreateAxaptaRecord(\"APMObjectTable\");\r\n    AxaptaRecord WarrantyTableRecord = DynAx.CreateAxaptaRecord(\"WarrantyInvoiceTable\");\r\n    tableArray[0] = APMObjectTableRecord;\r\n    tableArray[1] = WarrantyTableRecord;\r\n    \r\n    DynAx.ExecuteStmt(\"select * from %1 join %2\", tableArray);\r\n\r\n    while (APMObjectTableRecord.Found)\r\n    {\r\n        string Id = (string)APMObjectTableRecord.get_Field(\"APMObjectId\").ToString();\r\n        string Amount = (string)WarrantyTableRecord.get_Field(\"Amount\").ToString().ToString();\r\n\r\n        APMObjectTableRecord.Next();\r\n    }\r\n}\r\ncatch (Exception ex)\r\n{\r\n    MessageBox.Show(ex.Message, \"Don't Panic!\");\r\n}\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>try { AxaptaRecord[] tableArray = new AxaptaRecord[2]; AxaptaRecord APMObjectTableRecord = DynAx.CreateAxaptaRecord(&#8220;APMObjectTable&#8221;); AxaptaRecord WarrantyTableRecord = DynAx.CreateAxaptaRecord(&#8220;WarrantyInvoiceTable&#8221;); tableArray[0] = APMObjectTableRecord; tableArray[1] = WarrantyTableRecord; DynAx.ExecuteStmt(&#8220;select * from %1 join %2&#8221;, tableArray); while (APMObjectTableRecord.Found) { string Id = (string)APMObjectTableRecord.get_Field(&#8220;APMObjectId&#8221;).ToString(); string Amount = (string)WarrantyTableRecord.get_Field(&#8220;Amount&#8221;).ToString().ToString(); APMObjectTableRecord.Next(); &hellip; <a href=\"http:\/\/foxware.co.uk\/?p=286\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/286"}],"collection":[{"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=286"}],"version-history":[{"count":1,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":287,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/286\/revisions\/287"}],"wp:attachment":[{"href":"http:\/\/foxware.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/foxware.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}