Hi Cetin,
Sorry to bother you again.
The SQL SELECT ran after I recoded the commands to match your example. Thanks for that example. I see the difference. I never had to qualify table names before. This is all new to me.
I only have one final question. I was expecting to see translated descriptions from my translated codes appear in my CURSOR named rpt which later goes into my report. WHen I browse my CURSOR named rpt I don't see the descriptions which I thought were just JOINED from each of the 6 translate tables. Does that mean I am doing the wrong kind of join?
I want "OTHER" to appear in rpt.desc1 so my report show OTHER and not OT (the code for other). But I have no field called desc1 in my CURSOR rpt. Or do I have to CREATE CURSOR rpt first and put those new fields in ahead of time, before SQL SELECT?
Thanks for the final time today. I really appreciate your time and effort.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.