Re: RecordsetPtr & Command's Execute() method

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/27/04 

Date: Thu, 26 Feb 2004 22:53:29 -0500

Hi Chris,

Do you want to say that you do not like recordcount -1? If yes, then it is
expected result in your case, because recordset is read-only, forward-only
and provider is not capable to return actual record count in this case, but
recordset is opened and you could use it. Check next KB for more information

http://support.microsoft.com/default.aspx?scid=kb;en-us;194973 

-- 
Val Mazur
Microsoft MVP
"Chris Martin" <nospam@please11111.net> wrote in message 
news:o_x%b.130127$jk2.542397@attbi_s53...
>I am trying to get back data from a "SELECT" query, and am having trouble
> doing anything with the RecordsetPtr returned from a Command's Execute()
> method.  The docs say:
>
>> The returned Recordset object is always a read-only, forward-only cursor.
>
> Am I doing something incorrect in accessing the data from this Recordset? 
> I
> have gotten SELECT queries to work using Recordset's Open() method, but I
> wanted to use the Command's Execute() instead.
>
> If there is a good reason for using a different method, please explain.
>
> /* code simplified for brevity */
> _ConnectionPtr m_pConnection;
> _CommandPtr m_pCommand;
> _RecordsetPtr pRs;
>
> m_pConnection.CreateInstance(__uuidof(Connection));
> m_pCommand.CreateInstance(__uuidof(Command));
>
> m_pConnection->Open(m_strConn, lpstrUserID, lpstrPword, NULL);
>
> m_pCommand->ActiveConnection = m_pConnection;
> m_pCommand->CommandText = "SELECT * FROM Customers";
>
> pRs = m_pCommand->Execute(NULL, NULL, adCmdText);
>
> long count = pRs->GetRecordCount(); // returns -1
> _bstr_t str = pRs->GetString(adClipString, 1, ",", "\n", ""); // returns
> garbage
> /* end */
>
> TIA,
> C. Martin
>
>

Relevant Pages

  • Re: recordset not opening even though query analyzer returns resul
    ... I'm convinced that VB can execute this complex SP. ... > only way i could get an earlier version of it to return in a recordset. ... > table into a cursor and add up th evalues of the ccjs based on values in ... >> execute a query the SQL engine returns a resultset. ...
    (microsoft.public.vb.database.ado)
  • Re: UPDATE query in Access 2003 raising error
    ... The only reason I questioned the recordset is that you could conceivably ... the SQL looks fine to me. ... Set qdfTemp = db.CreateQueryDef ... Elsewhere in the code I use the same technique to execute an SQL statement ...
    (microsoft.public.access.formscoding)
  • Re: DAO peculiarity in A97?
    ... If BOF is True then you won't execute the statements inside the ... If..Then becuase you have told it to continue only if the opposite of BOF is ... only thing you do with it is open a recordset. ... This will force you to DIM each variable you ...
    (comp.databases.ms-access)
  • RE: Still struggling
    ... DLookup is much faster to execute and easier to code than creating, opening, ... using SQL is always faster than recordset processing. ... But, you do have to use the dbFailOnError option because without it, Access ...
    (microsoft.public.access.forms)
  • Re: GetRows Method
    ... Therefore the time to execute the Open is constant in both scenarios. ... It moves the data from the recordset to the aVarray, ... The article stated "The GetRows method is used to pull all the records from the recordset into an array." ... The usual purpose of opening a recordset is to process data. ...
    (microsoft.public.vb.database.ado)