E10 DynamicQuery in external Application

Yahoo Archive
1

That did it –

 

Thanks!!!

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 17, 2015 3:12 PM
To: Vantage
Subject: Re: [Vantage] E10 DynamicQuery in external Application

 




​Looks like your Execution-filter table is not instantiated

Try adding

QeT.ExecutionFielter = new .... 

Before you call the add method.​

 

 

 



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Mar 17, 2015 at 3:05 PM, bwalker@... [vantage] <vantage@yahoogroups.com> wrote:

 

Has anyone tried to use a dynamic query in an external application?

I am running into an Object Null exception and I am having a difficult time trying to decipher why.

 

Code:

 

QueryExecutionTableset qeT = new QueryExecutionTableset();
ExecutionFilterRow qeR = new ExecutionFilterRow();

qeR.DataTableID = "JobMtl";
qeR.FieldName = "JobNum";
qeR.CompOp = "=";
qeR.RValue = txtJobNum.Text;
qeR.RowMod = "A";
qeR.SysRowID = Guid.NewGuid();

qeT.ExecutionFilter.Add(qeR);  <-  Object reference not set to an instance of an object.

 




2

Has anyone tried to use a dynamic query in an external application?

I am running into an Object Null exception and I am having a difficult time trying to decipher why.


Code:


QueryExecutionTableset qeT = new QueryExecutionTableset();
ExecutionFilterRow qeR = new ExecutionFilterRow();

qeR.DataTableID = "JobMtl";
qeR.FieldName = "JobNum";
qeR.CompOp = "=";
qeR.RValue = txtJobNum.Text;
qeR.RowMod = "A";
qeR.SysRowID = Guid.NewGuid();

qeT.ExecutionFilter.Add(qeR);  <-  Object reference not set to an instance of an object.

3
​Looks like your Execution-filter table is not instantiated
Try adding
QeT.ExecutionFielter = new ....Â
Before you call the add method.​





Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Mar 17, 2015 at 3:05 PM, bwalker@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p><span>Has anyone tried to use a dynamic query in an external application?</span></p><p><span>I am running into an Object Null exception and I am having a difficult time trying to decipher why.</span></p><p><span><br></span></p><p><span>Code:</span></p><p><span><br></span></p><p><span>QueryExecutionTableset qeT = new QueryExecutionTableset();<br>ExecutionFilterRow qeR = new ExecutionFilterRow();</span></p><p><span>qeR.DataTableID = &quot;JobMtl&quot;;<br>qeR.FieldName = &quot;JobNum&quot;;<br>qeR.CompOp = &quot;=&quot;;<br>qeR.RValue = txtJobNum.Text;<br>qeR.RowMod = &quot;A&quot;;<br>qeR.SysRowID = Guid.NewGuid();</span></p><p><span>qeT.ExecutionFilter.Add(qeR);Â  &lt;-Â  Object reference not set to an instance of an object.</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>