Hi,
Is there a way to directly compare the fields of different domains.
For example,
here the length of tp and tf fields are different.
select tpppc295.* from tpppc295
where tpppc295.cico = :tfgld106.leac

The query is returning no rows. Any suggestions please..

Hi,

you can use tt.align.according.domain to move one field in domain a to a field in domain B

rc = tt.align.according.domain(string a, string B, "Domain name")

don't forget to include <bic_tt>

Regards
Philippe

Hi,
How can you compare fields belonging to different domains ??

Regards,
Amit

Length of tpppc295.cico is 8
Length of tfgld106.leac is 12

Maybe this will work:

select tpppc295.* from tpppc295
where tpppc295.cico = :1
wherebind(1, tfgld106.leac(1;8))

If tfgld106.leac is filled with more than 8 characters, it will make no sense.