News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... SQL Statement in CIL ...

Finance | Project Operations, Human Resources, ...

Answered

SQL Statement in CIL returns wrong data

(0) Share

Report

Report

Posted on by CRSW

621

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?

All responses Img

All responses (4)

Answers Img

Answers (1)

CRSW 621 on at

Like (0)

Report

RE: SQL Statement in CIL returns wrong data

ah thx for the advice. I will check this
CRSW 621 on at

Like (0)

Report

RE: SQL Statement in CIL returns wrong data

as I mentioned. in the job YES. In CIL not
Verified answer

Martin Dráb 232,866 Most Valuable Professional on at

Like (1)

Report
RE: SQL Statement in CIL returns wrong data

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.
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: SQL Statement in CIL returns wrong data

Hi CRSW,

Did you try debugging it to check if the statement returns a record?

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,099 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans