<div>
&gt;that returns -1 RecordCount<br />
that happens because you open on ServerSide instead of ClientSide cursor location, usually.<br />
<br />
anyhow, do you really need the recordcount itself, or just if there are records or not =&gt; use bof and eof instead.
</div>


>that returns -1 RecordCount
that happens because you open on ServerSide instead of ClientSide cursor location, usually.

anyhow, do you really need the recordcount itself, or just if there are records or not => use bof and eof instead.

<div>
And in case you did not get the message: &nbsp;The RecordCount property should not be used.
</div>


And in case you did not get the message:  The RecordCount property should not be used.

<div>
When I needed to get the RcordCount value of my Cursor I changed for adOpenStatic, adLockReadOnly and I was able to get the right value <br />
Thanks for everybody &nbsp;
</div>


When I needed to get the RcordCount value of my Cursor I changed for adOpenStatic, adLockReadOnly and I was able to get the right value
Thanks for everybody  

<div>
<div class="content wysiwyg-content">
Hi <br />
I'm programming with VBA for Excel, and I have a SELECT instruction that returns -1 RecordCount. <br />
<br />
Here is my Slect Instruction : <br />
RsPortes.Open &quot;Select SONumber, NumSection, Qty, UniteMesure, ItemNumber, ItemName, DFTPICKINGLISTOPR FROM V_Portes WHERE V_Portes.SONumber='&quot; &amp;&nbsp;NumJob &amp;&nbsp;&quot;'&quot;, MaConnectionAxaptaData, adOpenDynamic, adLockOptimistic<br />
<br />
The V_Portes is an SqlServer2005 view that is build with a Group By, it is working fine and getting the right results. <br />
<br />
How can I get my recordset lines within VBA Excel code ? <br />
<br />
Thanks &nbsp; <br />
<br />
<br />

</div>
</div>


Hi 
I'm programming with VBA for Excel, and I have a SELECT instruction that returns -1 RecordCount. 

Here is my Slect Instruction : 
RsPortes.Open "Select SONumber, NumSection, Qty, UniteMesure, ItemNumber, ItemName, DFTPICKINGLISTOPR FROM V_Portes WHERE V_Portes.SONumber='" & NumJob & "'", MaConnectionAxaptaData, adOpenDynamic, adLockOptimistic

The V_Portes is an SqlServer2005 view that is build with a Group By, it is working fine and getting the right results. 

How can I get my recordset lines within VBA Excel code ? 

Thanks   




VB6 Recordset is empty when records exist in my View because of Group By

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.