I can do this with a way which I got from a forum forumda . Trick is fetchMode command. Without fetchMode command can't generate a correct select command.
Query query = new Query();
QueryBuildDataSource qbds,qbds1,qbds2;
;
qbds = query.addDataSource(tableNum(SMAServiceOrderTable));
qbds1 = qbds.addDataSource(tableNum(B_RepairJournal));
qbds1.fetchMode(QueryFetchMode::One2One);
qbds1.addLink(fieldNum(B_RepairJournal,ServiceOrderId),fieldNum(SMSServiceOrderTable,ServiceOrderId));
qbds2 = qbds.addDataSource(tableNum(InventTable));
qbds2.fetchMode(QueryFetchMode::One2One);
qbds2.addLink(fieldNum(SMAServiceOrderTable,ItemId),fieldNum(InventTable,ItemId));
info(qbds.toString());
10 Ekim 2013 Perşembe
1 Ekim 2013 Salı
AXAPTA - Web service "CLR object cannot be marshaled to Microsoft Dynamics anytype." error
SenderTel2 = line.get_senderTel2();
If you get "CLR object cannot be marshaled to Microsoft Dynamics anytype." error message when reading value from any services property when value is null and can't hide this error even use try/catch, you have to do:
SenderTel2 = CLRInterop::isNull(line.get_senderTel2()) ? "" : line.get_senderTel2();
If you get "CLR object cannot be marshaled to Microsoft Dynamics anytype." error message when reading value from any services property when value is null and can't hide this error even use try/catch, you have to do:
SenderTel2 = CLRInterop::isNull(line.get_senderTel2()) ? "" : line.get_senderTel2();
Kaydol:
Kayıtlar (Atom)