Subject Re: [IBO] Master Detail Structure with IBOQery
Author Helen Borrie (TeamIBO)
At 05:53 PM 31-05-02 -0300, you wrote:
>Hi Helen,
>
>Taking a 'ride' from this question, I'd like to ask you about two other
>related things:
>
>1) If I link the detail to the master query by its datasource property WITH
>the where clause using a parameter, will It cause any scrolling problems?
>(by far, everything seems ok).

I don't know - try putting an ib_monitor into your app and see whether it
makes any difference to the SQL that is posted in your scrolling event.

>2) If I have a detail query, and change the master query at run-time by
>setting the datasource property constantly (as the user changes a tabsheet
>of a page control, for example). Do I need to close/open the detail query to
>reflect the changes or there is a method to do so? Suggestions
>appreciated...

It's my feeling that the detail dataset would have to be unprepared in
order for the datasource swap to "take", if the switch requires a change in
the underlying WHERE criteria; but otherwise not. But, rather than my
theorising, I suggest you try out what is the minimum you need to do for
this switching. I don't know of any single method you can call to do all
of the switching steps transparently. It seems to be the kind of unusual
requirement that needs some code tricks.

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com