April 22nd, 1999, 07:35 PM
Hi:
In my application,I use MFC CRecordSet Class to access a Datebase(Access 7.0).In this Datebase,there are three table (named is files","subjects","units".
"files" have filesname,filesid,subjectid,"sujects" have sujectname,sujectsid,unitsid,"units"have unitsname unitid, such as.).
I select all in the wizard.When the sql"select * from files,suject and units where ....." it work well,but when I want to query only one table there is some error ,such this "select * from units",but the m_unisname is null,and the m_filename is the right string get from table,what's error with this,my program or mfc? I hoped you can help me!
thanks!
(my e-mail address is liukang@263.net )
In my application,I use MFC CRecordSet Class to access a Datebase(Access 7.0).In this Datebase,there are three table (named is files","subjects","units".
"files" have filesname,filesid,subjectid,"sujects" have sujectname,sujectsid,unitsid,"units"have unitsname unitid, such as.).
I select all in the wizard.When the sql"select * from files,suject and units where ....." it work well,but when I want to query only one table there is some error ,such this "select * from units",but the m_unisname is null,and the m_filename is the right string get from table,what's error with this,my program or mfc? I hoped you can help me!
thanks!
(my e-mail address is liukang@263.net )