[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ms-atl
Subject:    ATL3 consumer templates re-issuing a parameterised query
From:       Tim Duckworth <tim () DUCKSOFT ! CO ! UK>
Date:       1998-09-29 22:51:28
[Download RAW message or body]


Hi

NT 4, VC 6, ATL 3

When using the ATL consumer templates for OLE DB on a parameterised query
how are you supposed to change the value after the query has been opened?
 Eg

rsQuery.m_id = 14;
rsQuery.Open()
while (rsQuery.MoveNext() == S_OK)
{
  Process result set with ID = 14
}

// ***

rsQuery.m_id = 37;  // Some other value
rsQuery.Open()
while (rsQuery.MoveNext() == S_OK)
{
  Process result set with ID = 37
}

I have found that you need to do rsQuery.m_session.Close() before the
second query is run.  Is this be correct?

TIA

Tim

----------------------------------------------------------------
Users Guide http://www.microsoft.com/workshop/essentials/mail.asp
contains important info including how to unsubscribe.  Save time, search
the archives at http://discuss.microsoft.com/archives/index.html

[prev in list] [next in list] [prev in thread] [next in thread]