Error in Recordset

Following peice of code is giving error as in attachment, please help


#include "stdafx.h"
#include <iostream.h>
#include <afxdb.h>

int main(int argc, char* argv[])
{
CDatabase myDatabase;
CString strConnect;

strConnect = _T("DSN=DB110_32;User Id=#ISL1Q1;PASSWORD=SYSLOG01;SRVR=DB110;DB=ccyud001;UID=#ISL1Q1;");
try
{
myDatabase.OpenEx(strConnect);
}

catch(...)
{
cout << "Error in opening Database" << endl;
return 0;
}
cout << "connection is successful" << endl;

try
{
CRecordset rs(&myDatabase);

rs.m_strSort = "proj_num, contact_name";

rs.Open(CRecordset::dynaset,_T("ccy003_proj"));
rs.Close();
}

catch(...)
{
cout << "again some error in rs" << endl;
return 0;
}

myDatabase.Close();
return 0;
}

You have to derive your recordset from the CRecordset class and bind all columns you need to the variables prior to call the recordset’s Open member function. Use the ClassWizard to create a CYourRecordset class derived from the CRecordset and bind columns. The columns will be bound to the variables in the CYourRecordset:: DoFieldExchange function.

Also catch a CDBException* not ... and get its error message.

Also, click retry when you get an assertion to see exactly what code caused the assertion.

Thanks for your help. I have done the following changes.
I have dereived a class from Crecordset and done DoFieldExchange as below
====
class CMyProjectClass : public CRecordset
{
public:
CMyProjectClass();
virtual ~CMyProjectClass();
virtual void DoFieldExchange( CFieldExchange* pFX );

int m_nProjectNumber;
CString m_strCustomerName;

};


CMyProjectClass::CMyProjectClass()
{

}

CMyProjectClass::~CMyProjectClass()
{

}

void CMyProjectClass::DoFieldExchange( CFieldExchange* pFX )
{
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Text(pFX, "contact_name", m_strCustomerName);
RFX_Int(pFX, "proj_num", m_nProjectNumber);
}

====

In the main file, I have done

====
try
{
CRecordset rs(&myDatabase);

rs.Open(CRecordset::dynaset,_T("select contact_name,proj_num from ccy003_proj"));
rs.Close();
}
====

Still, I am getting the same error. Can you help me?

Sunny

First of all sorry for those smiles (I dont know how did they creap in)
When I tried to debug, I got error in afxwin1.inl at..

======
_AFXWIN_INLINE HINSTANCE AFXAPI AfxGetResourceHandle()
{ ASSERT(afxCurrentResourceHandle != NULL);
return afxCurrentResourceHandle; }
======

Sunnypriya

I have solved the problem, but still unable to reach my final solution.
(reason snapshot is allowed)

==========================

try
{
CMyProjectClass rs(&myDatabase);
rs.Open(CRecordset::snapshot,_T("Select proj_num, contact_name from dbo.ccy003_project"));
cout << rs.m_strCustomerName << endl;
rs.MoveNext();
cout << rs.m_strCustomerName << endl;
rs.Close();

}

catch (CDBException* myexcept)
{
cout << myexcept->m_strError << endl;
return 0;
}

==========================

Problem, at the statemet rs.Open ......
I am forced to give all the details again, (please see the attachement for the steps).
Once I did, CDBException exception is raised, with reason
====================
No columns were bound prior to calling SQLFetchScroll/SQLExtendedFetch
====================

Thou, I have coded below part.

void CMyProjectClass::DoFieldExchange( CFieldExchange* pFX )
{
pFX->SetFieldType(CFieldExchange::outputColumn);
RFX_Text(pFX, "contact_name", m_strCustomerName);
RFX_Int(pFX, "proj_num", m_nProjectNumber);
}


Now, will this function be called implicitly or I have to call explicitly? How do I have to call? what is the method to bound the columns?


Hope answer to this will solve my problem.

Regards
SUNNYPRIYA

This code should help you to find the problem with the exception.

Code:

---

try
{
CMyProjectClass rs(&myDatabase);
rs.Open(CRecordset::snapshot,_T("Select proj_num, contact_name from dbo.ccy003_project"));
while(!rs.EOF())
{
    cout << rs.m_strCustomerName << endl;
    rs.MoveNext();
}
rs.Close();

}
catch (CDBException* myexcept)
{
cout << myexcept->m_strError << endl;
return 0;
}

---

I am getting the following exception
============
No columns were bound prior to calling SQLFetchScroll/SQLExtendedFetch
============

Could you post the CMyProjectClass files?

I am posting the file..
please help..

Your recordset files are not complete. Use Class Wizard to generate these files (View->ClassWizard->Add Class->New).

Hi, I have done some R&D and able to solve the problem, I am not getting any error, but values of the variables are the same as they have been set in the constructor.
I think we are close to answer, please help.
I am attaching the files again.

You don't need the select statement in the recordset open. The CRecordset class handles all that for you. I don't know if that's your current problem, but it's definitely a problem.

Quote:

---

Originally Posted by SunnyPriya

Hi, I have done some R&D and able to solve the problem, I am not getting any error, but values of the variables are the same as they have been set in the constructor.
I think we are close to answer, please help.
I am attaching the files again.

---

Use the Class Wizard to generate your recordset files. In your files the macros in *.cpp (AFX_FIELD_INIT, AFX_FIELD_MAP AFX_FIELD) and *.h (AFX_FIELD, AFX_VIRTUAL) are missed. I have attached sample files generated by the Class Wizard.

Quote:

---

Originally Posted by GCDEF

You don't need the select statement in the recordset open. The CRecordset class handles all that for you. I don't know if that's your current problem, but it's definitely a problem.

---

It's not true. The CRecordset class doesn't do it for you. You have to specify the select statement in the recordset open function.

Thanks every one.
I have solved the problem, It was my first program out of C++, I mean involving MFC, etc
I really appreciate evey one involved in helping me, esp Amarcode.
Thanks a lot again.
Regards
Sunnypriya

Quote:

---

Originally Posted by amarcode

It's not true. The CRecordset class doesn't do it for you. You have to specify the select statement in the recordset open function.

---

Dude, I've been working with CRecordsets for 10 years. You don't need to specify a select statement. I have NEVER specified a select statement. If you need to, then you are doing something wrong. :mad:

Quote:

---

Originally Posted by GCDEF

Dude, I've been working with CRecordsets for 10 years. You don't need to specify a select statement. I have NEVER specified a select statement. If you need to, then you are doing something wrong. :mad:

---

You can pass NULL parameter to the CRecordset Open function. In this case the default SQL statement is used, but you have to specify this statement in derived from CRecordset class function GetDefaultSQL().

Quote:

---

Originally Posted by amarcode

Moron, you can pass NULL parameter to the CRecordset Open function. In this case the default SQL statement is used, but you have to specify this statement in derived from CRecordset class function GetDefaultSQL().

---

Which is it? First you say that you have to pass a select statement to the Open function then you say it can be NULL. And you call me a moron - sheesh.

If you use class wizard to create your CRecordset derived class, you don't need to write any select code yourself. GetDefaultSQL should return a table name, not a complete select statement. CRecordset builds the select statement for you using the table name that class wizard inserts in your coce. You don't even need to create a CDatabase object.

If you're going to give advice and go around calling people names, you should have some clue what you're talking about.