Hi All,
i have data source table RetailTransactionPaymentTrans, i want to get state, county, and address fields from LogisticsPostalAddress Table, i'm using this peace of code but still faild...
str storeVale, storeValue2, storeValue3;
container workFlowContainer;
while select logisticsPostalAddress
join logisticsPostalAddress
where retailTransactionTable.LogisticsPostalAddress== logisticsPostalAddress.RecId
join retailTransactionTable
where retailTransactionTable.transactionId== paymentTransTable.transactionId
|| retailTransactionTable.store== paymentTransTable.store
|| retailTransactionTable.terminal== paymentTransTable.terminal
storeVale = postalAddressView.County;
storeValue2 = postalAddressView.Address;
storeValue3 = postalAddressView.State;
workFlowContainer = conIns(workFlowContainer,1, storeVale);
workFlowContainer = conIns(workFlowContainer,2, storeValue2);
workFlowContainer = conIns(workFlowContainer,3, storeValue3);
return workFlowContainer;
... please help me where i miss the logic ?
*This post is locked for comments