JOIN on 2 datasets?

  • Thread starter Thread starter mirax_00
  • Start date Start date
M

mirax_00

Can I code a JOIN on 2 datasets the same as 2 tables in a database or
do I have to retrieve the table by index or something of the table and
JOIN those? There's only 1 table in each ds...
 
Can I code a JOIN on 2 datasets the same as 2 tables in a database or
do I have to retrieve the table by index or something of the table and
JOIN those? There's only 1 table in each ds...
Click to expand...
--There's really nothing to "Join" in respect to a dataset so if I
understand you correctly, the short answer is 'no'. You always relate
tables, datasets are just containers for tables so there's nothing to relate
them on per se. The way you'd get at that functionality though is to either
have all the tables contained in the same collection(DataSet) . If you
don't mind me asking, what specifically are you trying to accomplish, maybe
I can help you get there with a different approach.

HTH,

Bill
 
For clarification each dataset only had 1 table returned in it and I
needed to join them. Thanx btw Cor, that's similar to what I ended up
doing to get it to work. Ended up copying the single tables returned
in those datasets and adding them to a master dataset and relating them
in it...as long as it works that was no biggie to me ;)

Jayyde
 
Back
Top