Re: Slow Retrieval in Forms Multi-Block

The four detail blocks are of a master-detail relation. The are automatically updated via the detail triggers that are automatically created in Dev2000 when you create the detail relationships. I must confess, I have never examined these automatically built triggers in great detail, just glanced at them. Is is possible to automatically retrieve the detail of the first record, and then turn off the automatic retrieval when the LAST_RECORD command is issued via the button?

TIA,
Ed

Louise Weiler wrote:

> Ed --
>
> Are the four related blocks detail blocks of a master-detail relation or are
> they truly correlated on the same level? The reason I ask -- I had a
> similar issue, and what I ended up doing was deferring the auto-query on the
> detail blocks in the master-detail relation, and only doing the query "on
> command" (like for the record that was currently displayed, not for ALL of
> the records when the user went to a "last record" or a "first record"). It
> cut my processing time by something like 75%.
>
> Just a thought....
>
> Louise
>
> Ed Jennings wrote in message <3671CD09.661E60E0_at_mindspring.com>...
> >I have a multi-block Form that contains relationships from the primary
> >block to four other blocks. In addition, there are three data elements
> >in the primary block that are pointers to a reference table. I use a
> >POST-QUERY trigger to populate non-database fields with the actual
> >values from the reference table, so that the display has more meaning to
> >the users.

--
~~~~~~~~~~~~~~~~~~~~~~~~~
jenningse_at_mindspring.com

"The opinions expressed here are my own, not those of DOMAIN technologies"