Dynamic Query write updates back to database

[LBARKER (Lawson Barker)]

Ok, I’ve found what I was doing wrong and now have it working…
I needed to declare the following in the Script area

DynamicQueryAdapter yourbaq;
DataTable results;

With that done, I could then use them outside of the private void (this may seem common sense to seasoned users but I’m still cutting my teeth on customizations)

I then was able to add the suggestion from @rosshughes

I got the idea to declare them from this post

Run Updateable BAQ from customisation [C#]

it is not updating, there is no errors private void btnRetrieve_Click(object sender, System.EventArgs args) { // ** Place Event Handling Code Here ** FillPendingRequests(); } DynamicQueryAdapter yourbaq; DataTable results; private void FillPendingRequests() { yourbaq = new DynamicQueryAdapter(this.oTrans); yourbaq.BOConnect(); string baqname = "Ex_PendingStkMove"; //yourbaq.ExecuteByID(baqname, dsBAQ); yourbaq.GetByID(baqname); Ice.BO.DynamicQueryDataSet ds = yourbaq.DynamicQu…

Thank you @dhewi for the bones of the DQA