I am trying to display the values of RoutingNo from a Bank Table.

Bank Table Key=ComapnyNumber and BankNo

I also the same fields in my employees table ====]Emp.EFT

My failing formular is as follows:

@Ans=xlate("BANK.TABLE", {COMPANYNUMBER}*{BANKNO},"ROUTINGNO","X")

I will appreciate it if someone could show me how to do this correctly. I do not know where my problem lies.

Thanks

Tom

Tom,

Looks like you need quotes around your * in the Key. Otherwise you are

multiplying company number by bank number !

I think you want {COMPANYNO}:'*':{BANKNO}.

regards

Warren Kinny

warren@resmaster.com

Your code is subject to confusion in interpretation

You use :-

@Ans=xlate("BANK.TABLE", {COMPANYNUMBER}*{BANKNO},"ROUTINGNO","X")

We would set a new variabls , say ANS1={companynumber}

then another varaible, say ANS2={bankno}

then combine them thus:-

ANS3=ANS1:'*':ANS2

Set another variable ANS4={routingno} then use them thus:-

@Ans=xlate("BANK.TABLE",ANS3,"ANS4","X")

This would significantly simplify your code and have predictable

response.

Kevin Gray

GRAYCORP

email keving@graycorp.com.au

I seem to have missed your point entirely.

Could you please explain what possible benefits might flow from introducing four extra variables with meaningless names?

The original problem seems to me to be entirely about confusion between concatenation and multiplication when forming the multi-part record key.

I agree with Chris. Anyway this code:

]]Set another variable ANS4={routingno} then use them thus:-

]]@Ans=xlate("BANK.TABLE",ANS3,"ANS4","X")

wouldn't work becasue you have quotes around ANS4, thus the xlate function would treat it a literal.

The original query simply was confusion over concatenation.

View this thread on the forum...