P
Peter Judge
Guest
Where's your alias defined? What are you using to compile? From: James Palmer [mailto:bounce-jdpjamesp@community.progress.com] Sent: Thursday, 28 May, 2015 16:49 To: TU.OE.Development@community.progress.com Subject: [Technical Users - OE Development] Weird Alias problem Weird Alias problem Thread created by James Palmer I usually compile my code with my databases connected with a logical name, but for the moment I'm having to connect them as aliases for something. I have code that does this: FOR EACH ChargeRate WHERE ChargeRate.PriceListKey = PriceList.PriceListKey AND ChargeRate.ChargeBandKey = ChargeBand.ChargeBandKey NO-LOCK. FIND ICMAS.BlockRange WHERE ICMAS.BlockRange.BlockRangeKey = ICMAs.ChargeRate.BlockRangeKey NO-LOCK NO-ERROR. When I compile with a logical dbname of ICMAS is compiles fine, but when I try and compile with aliases I get ** Missing FOR, FIND or CREATE for a table with BlockRangeKey in current block. (232) If I qualify the ChargeRate for each with ICMAS. then it also compiles ok. Unfortunately I have around 250 pieces of code exhibiting this chestnut and fixing them isn't an option right now (although it could be an entertaining project for a minion one day!) Short of connecting with the right logical dbname, is there anything I can do to get my alias compile to work properly? Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...