Re: Implementing Select * in ADO

From:

Cholo Lennon <chololennon@hotmail.com>

Newsgroups:

microsoft.public.vc.mfc

Date:

Sun, 15 Aug 2010 21:19:37 -0300

Message-ID:

<i4a06p$a20$1@speranza.aioe.org>

ADO programming is very simple, it's similar to VB. If you have multiple
fields in a recordset (or just only one) use the Item property:

ADODB::_Recordset pRs;
....

pRs->Item["FieldName1"]->Value = fieldValue1;
pRs->Item["FieldName2"]->Value = fieldValue2;

....

Regards

--
Cholo Lennon
Bs.As.
ARG

dushkin wrote:

Hi,

I have the following code:

// sField = "some column name"

                        m_pRecordset->Open((LPCSTR)a_sQuery,
                                    m_pConnection.GetInterfacePtr(),
                                    adOpenDynamic,
                                    adLockOptimistic,
                                    adCmdText);

                        while(!m_pRecordset->adoEOF)
                        {
                                    TheValue = m_pRecordset-

GetCollect((char*)_bstr_t(sField));

if(TheValue.vt!=VT_NULL){

m_pRecordset-

Close();

return((char*)_bstr_t(TheValue));
                                    }
}

It works fine when the select query has one column to select.

But what should I do if the query is of " select * " type ?

I tried the following and the GetCollect Failed:

// sField = "*"

                        m_pRecordset->Open((LPCSTR)a_sQuery,
                                    m_pConnection.GetInterfacePtr(),
                                    adOpenDynamic,
                                    adLockOptimistic,
                                    adCmdText);

                        while(!m_pRecordset->adoEOF)
                        {
                                    TheValue = m_pRecordset-

GetCollect((char*)_bstr_t(sField));

                                    if(TheValue.vt!=VT_NULL){

                                                if(resBuf[0] = 0)

strcpy(resBuf, (char*)_bstr_t(TheValue));
                                                else

strcat(resBuf, (char*)_bstr_t(TheValue));

                                                strcat(resBuf, "|");

                                    }
                                    m_pRecordset->MoveNext();
                        }

                        m_pRecordset->Close();
                        return((char*)_bstr_t(TheValue));

Thanks!