Thank you SO much Helen!

I know I've said this before, but your selflessness never ceases to
amaze me.

> Yes. In my case, my "epiphany" with datasets came the day I

realised that

> the dataset is just a container for a SQL specification. If the

spec

> doesn't change, the container doesn't change.
>
> Search arguments (the column list in your WHERE clause) and ORDER

BY

> arguments (the column list in your ORDER BY clause) are part of

the

> STRUCTURE of the specification. If you change the COLUMNS that

are used

> for these arguments, you change the structure of the specification

and so

> the container gets emptied and reconstructed to reflect the

structural

> change. If the only thing you change in the WHERE clause is the

value that

> gets pushed into the search spec, you aren't changing the
> structure. (Alternative ORDER BY always changes the structure...)
>
>
> >Thanks again for your help. I have been a little verbose, but this
> >HAS to be properly understood by me before I move on.
>
> Yep - agreed - and when the penny drops, you tend to move on

faster. :-))


Bing! I feel a penny has just dropped! (well, maybe not a penny, but
I think the purse has dropped. I just need to get the penny out!)

I can't thank you enough, Helen.
(This is not to take away from the other extremely giving guru's
here.)

Rgds,
-Ryan