Potentially stupid question RE datasets

Posted by ojfoggin on 28-Jan-2010 04:27

I've got a question regarding datasets.

If I define 3 temp tables...

tt-1

tt-2

tt-3

(for simplicity's sake).

and 2 datasets...

DS-A for tt-1 tt-2.

DS-B for tt-2 tt-3.

i.e. DS-A and DS-B overlap with tt-2.

If I then create a query to fill DS-A will that fill DS-B where the overlap occurs?

I hope that makes sense?

If so I can rewrite it fairly easily and TBH it will prob make more sense when it's rewritten.

Thanks for any help.

All Replies

Posted by kevin_saunders on 28-Jan-2010 04:36

Not that I've tested it, but if the 2 Datasets are defined in the same procedure, then I believe it will fill tt-2..

Posted by ojfoggin on 28-Jan-2010 04:44

Thanks,

I thought so.

Posted by Thomas Mercer-Hursh on 28-Jan-2010 12:23

If you are wanting the tt-2 data to be the same in the two datasets, why are you not defining one dataset with all three tables?

Posted by ojfoggin on 29-Jan-2010 02:31

The program using these datasets was my first attempt and I was still learning.

I have gone through and changed the program to be more efficient in it's use of datasets now that I have a better understanding of how they work and I've ocmbined the DS-A and DS-B into one dataset.

Thansk

Oliver

This thread is closed