Announcements
No record found.
Hi
We do have customized code where I try to get a record via sql statement
select forupdate mytable where mytable .extNum == '000052' && mytable .dataAreaid == 'TRV'
The record exist in mytable
Running the code in a job to verify it works....running it in a class called in CIL it never gets the record
Any suggestions?
Hi CRSW,
Did you try debugging it to check if the statement returns a record?
Your code looks wrong to me. If the table is company-specific, therefore it has DataAreaId, and your intention is updating TRV company data from another company, you forgot crossCompany keyword:
select crossCompany forUpdate mytable where mytable.ExtNum == '000052' && mytable.DataAreaIdd == 'TRV';
Maybe you're running your job and your CIL code in two different companies.
as I mentioned. in the job YES. In CIL not
ah thx for the advice. I will check this
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 649
André Arnaud de Cal... 447 Super User 2026 Season 1
Syed Haris Shah 242 Super User 2026 Season 1
