Re: Forms3.0/Post-Query/update rows selected but not displayed

I'd suggest putting your processing on a KEY- trigger(maybe even KEY-STARTUP if you want it to happen on entry). This trigger can then (it's been a while so I may get the buitin names' wrong):

perform the query for you, execute_query; goto first record in the block go_record(1) while not on last record I'm sure there's an easy test to see if you're at the last record. Can't remember if it's a SYSTEM. variable or a builting function.
{

    perform your processing
    perform a 'down' or 'next_record' to move to next record; }
Go back to record number 1 so it's doesn't look like the screen has been scrolling
Perform a commit;
grin happily cos you've done it

--
Alan D. Mills

Corinna Becker wrote in message
<01bdba28$5444dfe0$a049100a_at_pc743-sode.seurope.ikea.com>...
>Hello,
>I have the following problem:
>
>We select several rows and make an update on them using the Post-Query
>trigger. Our problem is that when the number of rows selected is higher
>than the number of rows displayed the trigger does not fire for all rows
>selected but only for the rows displayed. Like this our data is not fully
>updated.
>
>The reason is that when the query has selected the number of rows displayed
>it pauses. It is reactivated e.g. when you press the scroll down key. So
>theoretically our users wouldn't have any problem when they would scroll
>down the whole screen and would then commit when they have reached the last
>row. As the number of data is too high this is not acceptable for them. So
>we have to do it automatically.
>
>But how can we do this? Somehow I have to find a way to force the query not
>to pause. But how can I do that? I tried the procedure "NEXT_SET" to fetch
>the next set of records (and then fire the Post-Query trigger again
>recursively). But NEXT_SET is a restricted procedure and is therefore not
>allowed in the Post-Query trigger.
>
>Maybe someone has a good idea what I can do there. Any help is welcome.
>Best regards
>Corinna
Received on Tue Jul 28 1998 - 09:34:25 CDT