>I'm glad to help, Ravi.
>
You are a good friend Steve:) Always good to hear from you.
> Since you don't care which patient is shown, it is not a problem for you.
>
True. The purpose of the first grid is only to show if there is something in a slot or not.
>Using SET ENGINEBEHAVIOR simply forces you to be aware that there is *potentially* a problem with a given SELECT statement (and that the problem potentially existed in previous versions). That is why I suggested that you turn it on and off, only for certain SELECT statements.
This means, if I am using Group By elsewher, I should add all of the other fields in the select statement except one which have aggregate or sum functions? And this will be better in teh future.
>I'll restate it this way: using SET ENGINEBEHAVIOR in VFP8 is not any more dangerous than using that same SELECT statement in another version of VFP.
>
>Do you understand the situation?
>
Perfect. Makes sense.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons