Hi everybody,
It's the first time that I post in this forum.
I can't resolve a basic issue with three datasource in a form.
DS1 Inventtrans is joined with DS2 WMSJournalTrans (with innerjoin mode by properties and using native links between tables)
DS2 WMSJournalTrans is joined with DS3 WMSJournalTable (with innerjoin mode by properties and using native links between tables)
How can i add by code (and where can I add this code?) a relation between DS1 InventTrans and DS3 WMSJournalTable to obtain this restriction WMSJournalTable.packingSlip = InventTrans.packingSlipID ?
Actually I wrote In init() method of DS3 WMSJournalTable:
QBDSWMSJournalTable = this.query().dataSourceName("WMSJournalTable");
QBR_WMSJournalTable = sysquery::findOrCreateRange(QBDSWMSJournalTable, fieldnum(WMSJournalTable, packingSlip));
QBR_WMSJournalTable.value(strfmt('%1.packingSlipID', inventTrans_ds.name()));
The result Query lokks like:
SELECT FIRSTFAST * FROM InventTrans WHERE ((TransType = 3)) AND InventTable.ItemId=InventTrans.ItemId
JOIN FIRSTFAST * FROM WMSJournalTrans WHERE InventTrans.InventTransId = WMSJournalTrans.inventTransId
JOIN FIRSTFAST * FROM WMSJournalTable WHERE WMSJournalTrans.journalId = WMSJournalTable.journalId AND ((packingSlip = N'inventtrans.packingSlipID'))
(in blue) It seem to be correct but there's no result in grid.
This query give me results in SQLServer.
Thanks a lot for support.
Regards
