india_bb
asked on
How to access records from ODBC in VC++(MFC)???
I am building a instant messenger in VC++
My problem is that i can access the records from the database using CRecordSet as shown:::
rs.Open(CRecordset::dynase
while(!rs.IsEOF() )
{
m_EmpNames[i] = rs.m_EmpLogin ;
wsprintf(outtext,"%s %d",m_EmpNames[i],i);
AfxMessageBox(outtext);
i++;
rs.MoveNext();
}
The query is getting executed properly but the problem is that i can't see the value in rs.m_EmpLogin where rs is an object of CRecordSet
I think that the values are not getting bound to the database fields????
i will be thankful for prompt replies
urs sincerely
india_bb
ASKER
hello Mr Triskelion
I did the thing which u said 'coz i am using CString array only ....thanx for it
The problem doesn't get solved ...
actually the loop executes as many times as it finds records in the database in that table but the value doesn't get bound to the variable of the CRecordSet class
that is rs.m_EmpLogin
Prompt reply will be highly appreciative
thanx
I did the thing which u said 'coz i am using CString array only ....thanx for it
The problem doesn't get solved ...
actually the loop executes as many times as it finds records in the database in that table but the value doesn't get bound to the variable of the CRecordSet class
that is rs.m_EmpLogin
Prompt reply will be highly appreciative
thanx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Derive a class from CRecordset, MFC will ask the DSN Name, so u just select it.
Then MFC will create a class containing the members with prefix "m_" .
GOOD LUCK
Then MFC will create a class containing the members with prefix "m_" .
GOOD LUCK
ASKER
Hello friend do u have a yahoo Id or hotmail id so that we can chat
thanx
Sorry, I 'm in office, u can comment out here.....
messengers are restricted here....
Have u tried my comment ?
regards
Roshmon
messengers are restricted here....
Have u tried my comment ?
regards
Roshmon
ASKER
Hello friend do u have a yahoo Id or hotmail id so that we can chat
thanx
Sorry, I 'm in office, u can comment out here.....
messengers are restricted here....
Have u tried my comment ?
regards
Roshmon
messengers are restricted here....
Have u tried my comment ?
regards
Roshmon
ASKER
Hello friend do u have a yahoo Id or hotmail id so that we can chat
thanx
Hello Friend,
I'm in OFFICE. There is no messengers allowded...
Regards
Roshmon
I'm in OFFICE. There is no messengers allowded...
Regards
Roshmon
ASKER
Hello
Mr Triskelion do u have a yahoo Id or hotmail id so that we can chat
thanx
Mr Triskelion do u have a yahoo Id or hotmail id so that we can chat
thanx
do something like:
rs.GetFieldValue(0,m_EmpNa mes[i]);
instead of:
m_EmpNames[i] = rs.m_EmpLogin ;
rs.GetFieldValue(0,m_EmpNa
instead of:
m_EmpNames[i] = rs.m_EmpLogin ;
Hi
>> m_EmpNames[i] = rs.m_EmpLogin ;
I am not sure about the data type rs.m_EmpLogin returns.
Can you pl mention the data type rs.m_EmpLogin belong while creating this table.
How you have configured your DSN ?
Which ODBC driver your DSN is configured to ?
I faced similary problem like i was not able get numeric values from the table even through query executed properly and i configured my DSN with Microsoft ODBC for Oracle and i was able to get both the string values and numeric values.
>> m_EmpNames[i] = rs.m_EmpLogin ;
I am not sure about the data type rs.m_EmpLogin returns.
Can you pl mention the data type rs.m_EmpLogin belong while creating this table.
How you have configured your DSN ?
Which ODBC driver your DSN is configured to ?
I faced similary problem like i was not able get numeric values from the table even through query executed properly and i configured my DSN with Microsoft ODBC for Oracle and i was able to get both the string values and numeric values.
Hi vcppmfc, welcome to EE.
All of the experts here, for the most part have learn from other experts as to the proper etiquette
for posting answer.
Please don't lock questions especialy when the questioner has asked that the question not be locked.
An answer should not be posted as an answer, if other experts have previously posted possible answers
as comments, and/or have already made contributions to the question.
There are many experts who never post answers as answer. Instead, they post their answers as comments.
If you read the following link, you'll see why this is the preferred method for many of our valued experts,
including myself.
https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp
Hi india_bb:
Feel free to click the [Reject Answer] button near vcppmfc's response, even if it seems like
a good answer.
Doing so will increase your chance of obtaining additional input from other experts. Later, you can
click the [Select Comment as Answer] button on any response.
All of the experts here, for the most part have learn from other experts as to the proper etiquette
for posting answer.
Please don't lock questions especialy when the questioner has asked that the question not be locked.
An answer should not be posted as an answer, if other experts have previously posted possible answers
as comments, and/or have already made contributions to the question.
There are many experts who never post answers as answer. Instead, they post their answers as comments.
If you read the following link, you'll see why this is the preferred method for many of our valued experts,
including myself.
https://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp
Hi india_bb:
Feel free to click the [Reject Answer] button near vcppmfc's response, even if it seems like
a good answer.
Doing so will increase your chance of obtaining additional input from other experts. Later, you can
click the [Select Comment as Answer] button on any response.
Hi Triskelion
What you say is correct.Sorry for the inconvenience.
What you say is correct.Sorry for the inconvenience.
Hi india_bb:
For the time beign you can take my answer as an comment.Do you have any thing to say about my comment i have already posted ?
For the time beign you can take my answer as an comment.Do you have any thing to say about my comment i have already posted ?
waiting for you feedback pl
ASKER
Thanx to all of the experts who particiapted in this quest
I got the answer
actually i need to make a different CRecordSet Object class for diffferent tables in my database
The mistake i did was that i was using same CRecordSet for different tables
hence it was giving such wage replies
My special thanx to mr Triskelion for his kind help
I got the answer
actually i need to make a different CRecordSet Object class for diffferent tables in my database
The mistake i did was that i was using same CRecordSet for different tables
hence it was giving such wage replies
My special thanx to mr Triskelion for his kind help
ASKER
Thanx to all of the experts who particiapted in this quest
I got the answer
actually i need to make a different CRecordSet Object class for diffferent tables in my database
The mistake i did was that i was using same CRecordSet for different tables
hence it was giving such wage replies
My special thanx to mr Triskelion for his kind help
I got the answer
actually i need to make a different CRecordSet Object class for diffferent tables in my database
The mistake i did was that i was using same CRecordSet for different tables
hence it was giving such wage replies
My special thanx to mr Triskelion for his kind help
hi india_bb
If you are using SELECT * from table query then single CRecordset object is enough.But if you are using UPDATE SQL Statements then for each table you should CRecordset object seperately and each fields should be binded.This how i solve similar problem.
If you are using SELECT * from table query then single CRecordset object is enough.But if you are using UPDATE SQL Statements then for each table you should CRecordset object seperately and each fields should be binded.This how i solve similar problem.
[...assuming the rs.m_EmpLogin is a CString...]
What data type is the m_EmpNames array?
If it is an array of CString, you may need to call GetBuffer(0) inside the wsprintf
wsprintf(outtext,"%s %d",m_EmpNames[i].GetBuffe
If it's not a CString array, you will have data type issues when assigning the rs.m_EmpLogin to it.