View Single Post
Old 10th July 2019, 19:03
mvanta mvanta is offline
Join Date: May 2004
Location: Athens HELLAS
Posts: 61
mvanta is on a distinguished road
Baan: LN 10.5 - DB: SQL 2014 - OS: Windows 2012
Thank you for your help and for answering!
It works but it returns only one of the companies, the logistic.
We need to have as well get.compnr() because the user should have 2 options:either the financial or the logistic.
We could get the financial from this sql,
select tcemm170.comp
from tcemm170
where tcemm170.comp = :comp

but how we could combine it to your code?

Reply With Quote