|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
try { AxaptaRecord[] tableArray = new AxaptaRecord[2]; AxaptaRecord APMObjectTableRecord = DynAx.CreateAxaptaRecord("APMObjectTable"); AxaptaRecord WarrantyTableRecord = DynAx.CreateAxaptaRecord("WarrantyInvoiceTable"); tableArray[0] = APMObjectTableRecord; tableArray[1] = WarrantyTableRecord; DynAx.ExecuteStmt("select * from %1 join %2", tableArray); while (APMObjectTableRecord.Found) { string Id = (string)APMObjectTableRecord.get_Field("APMObjectId").ToString(); string Amount = (string)WarrantyTableRecord.get_Field("Amount").ToString().ToString(); APMObjectTableRecord.Next(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Don't Panic!"); } |
AX BC- Query with Joins
This entry was posted in C# Development. Bookmark the permalink.