<div>
I not sure I understand exactly what your asking... <br />
could u clarify.?<br />
<br />
JAY 
</div>


I not sure I understand exactly what your asking...
could u clarify.?

JAY

<div>
thanks Jay yes - if i get an eof on the first select I want it to skip to the next select statement rather than returning a DTSTaskExecResult_Success <br />

</div>


thanks Jay yes - if i get an eof on the first select I want it to skip to the next select statement rather than returning a DTSTaskExecResult_Success


<div>
Then this is just what you want??? &lt;Smile&gt; <br />
<br />
let me know if you have any problems <br />
<br />
JAY 
</div>


Then this is just what you want??? <Smile>

let me know if you have any problems

JAY

<div>
you're right of course Jay - my code is breaking else where but i'll post another question for that - thanks for your help - have a good weekend!
</div>


you're right of course Jay - my code is breaking else where but i'll post another question for that - thanks for your help - have a good weekend!

<div>
you too!<br />
JAY ..<br />
<br />
PS.. thanks THAT grade just got me my MASTER level certificate... !!!!<br />
<a href="https://www.experts-exchange.com/M_3415762.html" rel="ugc">https://www.experts-exchange.com/M_3415762.html</a><br />
<br />
ALRIGHT!!!<br />
<br />
<br />

</div>


you too!
JAY ..

PS.. thanks THAT grade just got me my MASTER level certificate... !!!!
https://www.experts-exchange.com/M_3415762.html [https://www.experts-exchange.com/M_3415762.html]

ALRIGHT!!!




<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I use the following code in an activeX script following a select statement<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if rs.bof or rs.eof then noOrders = true<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if noOrders then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Main = DTSTaskExecResult_Success <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End if<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if not noOrders then.... etc<br />
<br />
My problem is that I'd like to add in another select statement further down the script and i don't want to have the message that it's been a success if the first query returns has an eof/bof....<br />
<br />
Anyone think of a way around it?<br />
<br />
Many Thanks
</div>
</div>


Hi Experts,

I use the following code in an activeX script following a select statement

          if rs.bof or rs.eof then noOrders = true
          if noOrders then
          Main = DTSTaskExecResult_Success 
          End if
          if not noOrders then.... etc

My problem is that I'd like to add in another select statement further down the script and i don't want to have the message that it's been a success if the first query returns has an eof/bof....

Anyone think of a way around it?

Many Thanks

Two Select Statements in an ActiveX DTS script

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.