web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Update lookup field with a direct sql command

(0) ShareShare
ReportReport
Posted on by 35

Hello

In the Quote entity, I have a custom lookup field pointing to a custom entity. For some reason, I must update this lookup field when the quote is in active state (readonly) and from an external application.

If I use CRM SDK I cannot update the field because the quote is in read-only state, so I thinking to do the operation with a direct sql update to the database changing the guid in the field.
Is it a good idea use this solution considering the field and the external entity are custom?
If not, have you some suggestions?

Thank you very much

Matteo V.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rawish Kumar Profile Picture
    13,758 on at

    Hi Matteo,

    It is never recommended and not a good idea to update anything directly in the database.

    there are few method you try to achieve this. :

    mscrmtechie.blogspot.co.uk/.../update-content-of-activated-quote.html

    mark my suggestion as verified if helpful.

  • Mahendar Pal Profile Picture
    45,095 on at

    Although you can do that as it's technically possible but this is not supported, so better to think about other options like suggested to change to draft mode and update and set back to activemode again.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans