Recordset related

  • Thread starter Thread starter sumesh
  • Start date Start date
S

sumesh

Hi everybody,

Can a recordset have more that one table in it.

As we have in Dataset(.net).

If so how?

Thanks
Sumesh
 
Hello Sumesh

You can create a recordset with the data from a query, which can join
several tables.

Ragnar
 
-----Original Message-----
Hello Sumesh

You can create a recordset with the data from a query, which can join
several tables.

Ragnar


.
Click to expand...

Hi Ragnar,

when we use query - eventually we will endup by having
one dataset i.e., One table (which has the value from
multi table or query) but I question is whether we can
have two unique tables in one recordset.

That's one of Advantage of using dataset in .net.

Thanks and Regards
 
Hi Sumesh,

A recordset is by definition a collection of data in memory that is
retrieved from one or more tables. The tables have to be joined on some
fields(s), except for UNION queries.

I am not sure what you mean by unique tables, to be useful the tables in a
recordset needs to be related in some way, otherwise you should use separate
recordsets.

Ragnar
 
Back
Top