I am accessing a DLL written in VB which has a number of methods. This DLL is designed to sign onto a sqlserver database and return various information depending on the methods called.
To date I have managed to CoCreateInstance and successfully access several of these methods.
My issue is this: Several of these methods return a record set with possibly multiple rows of data and I have no idea how to create a record set in VC++ and how access it.
This is the description of one of the methods I am trying to use:
Returns a RecordSet of all customer fields
In the attached code (I have removed pieces to make it easier to read), you can see how I have accessed some of the methods:
The method GetCustomerList requires the property of LastName to be set prior to calling and will return a RecordSet of all the Customers with the last name given.
How do I construct this record set and walk through it?
Thanks for all help
hresult=CoCreateInstance(clsid, NULL, CLSCTX_INPROC_SERVER, __uuidof(_WebRes), (LPVOID *)&wr);
bool bCon = wr->Connect("GXX", "");
bool bSUser = wr->SetUser("GXX");
wr->FirstName = "Davis";
wr->LastName = "Phil";
wr->PhoneNo = "123 456 7890";
wr->Display = "Davis, Phil";
wr->Email = "email@example.com";
bool bCust = wr->CreateCustomer(&bstrMess);
MessageBox(str); // this works fine
wr->LastName = _bstr_t ("Davis");
Record Set = wr->GetCustomerList(); // what to do here.
// the above call to GetCustomerList will return a RecordSet of all the customers with a
// last name Davis. The Record set will contain the information about each individual customer
// How do I create and access this recordset in 'C'