VB6 Recordset is empty when records exist in my View because of Group By
Posted on 2009-04-14
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 ?