Can you reference a Column in a BAQ DataView as a parameter in a Dynamic Query? I don’t know what I have wrong but it is throwing an error. I don’t think I’m calling the dataView correctly.
MessageBox.Show("Change Order Number Start");
MessageBox.Show(edvMyCustomOrderDV.dataView[edvMyCustomOrderDV.Row]["OrderNum"].ToString());
tbOrderCancelled.Visible = false;
tbOrderEditCompleted.Visible = false;
MessageBox.Show("Change Order Number Lines");
//Order Lines
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID("GS_Orders_Lines");
qeds.ExecutionParameter.Clear();
qeds.ExecutionParameter.AddExecutionParameterRow("OrderNum", edvMyCustomOrderDV.dataView[edvMyCustomOrderDV.Row]["OrderNum"].ToString() , "nvarchar", false, Guid.NewGuid(), "A");
dqa.ExecuteByID("GS_Orders_Lines", qeds);
gridLinesCopyChanges.DataSource = dqa.QueryResults.Tables["Results"];