Třídová akce

Kód:

27

Tělo:

select ID 
from Firms
where (Hidden = 'N') and (Firm_ID is null) 
and (OrgIdentNumber = :OrgIdentNumber)
and (VATIdentNumber = :VATIdentNumber)
and ((:UseName = 0) 
  or ((:IgnoreCase = 0) and (Name like :Name escape '~'))
  or ((:IgnoreCase <> 0) and (Upper(Name) like Upper(:Name) escape '~')))

Generated by ABRA Software a.s. 27.10.2021 16:34:09