Returning multiple tables from GetDefaultSQL()

Glenn T. Jayaputera -- gtj@nunkeen.apana.org.au
Thursday, February 15, 1996

Wondering if it is possible to return a multiple table  from GetDefaultSQL().
In ODBC you can do 
         return  "Customer, CustAcc";

for instance, can you do the same thing with CDaoRecordSet??  What is the format for it..

thanks
glenn tesla

---

Keith Faulkner -- keith@g4eqz.demon.co.uk
Thursday, February 29, 1996

In message <01BAFBC5.36430180@m3-207.bgsu.edu>, Glenn Tesla Jayaputera
 writes
>Wondering if it is possible to return a multiple table  from GetDefaultSQL().
>In ODBC you can do 
>         return  "Customer, CustAcc";
>
>for instance, can you do the same thing with CDaoRecordSet??  What is the format 
>for it..
>
Havent tryed returning 2 tables as such, what I did instead was create
an addittional recordset class which included the the fields from 2
tables. It seems to work fine. This was with DAO by the way not ODBC.

Keith 

Keith Faulkner
keith@g4eqz.demon.co.uk
Compuserve [100024,506]

Demon Internet ... The M25 of the Information Super Highway ...

---

Glenn T. Jayaputera -- gtj@nunkeen.apana.org.au
Sunday, March 03, 1996

> >Wondering if it is possible to return a multiple table  from GetDefaultSQL().
> >In ODBC you can do 
> >         return  "Customer, CustAcc";
> >
> >for instance, can you do the same thing with CDaoRecordSet??  What is the format 
> >for it..
> >
> Havent tryed returning 2 tables as such, what I did instead was create
> an addittional recordset class which included the the fields from 2
> tables. It seems to work fine. This was with DAO by the way not ODBC.
> 

Found the answer, should be

return "[Customer][CustAcc]";

cheers
glenn tesla

---

| Вернуться в корень Архива |