Using of two table in one CDaoRecordset object ...

[HadiRezaee]

Hi all,
I want to use of use of two table in only one CDaoRecordset object ...
Does i must use of two object ???

 

[Cagliostro]

virtual void Open(
AFX_DAO_USE_DEFAULT_TYPE,
"select * from table1 union select * from table2",
);
John Fill

ivfmd@mail.md

 

[HadiRezaee]

Hi John,
If i want to write value in NAME field in TABLE1 table then i write value in NAME field in TABLE2 !!!
How can i do that ?

 

[Cagliostro]

Oh, you can't have two different tables or queries in one single statement. Each table/query must have its statement. John Fill

ivfmd@mail.md

 

[HadiRezaee]

So, i must use of two object ?
Can i use of:
m_rs->SetFieldValue("TABLE1.NAME", "Hadi"

???

Is it true ?

 

[Cagliostro]

I don't know the specific of DAO, but you can't make changes to two different objects at the same time(ie in one single statement). John Fill

ivfmd@mail.md