Re: Need trigger for form.

I have done lots of such commit-refresh queries: Just use WHEN-BUTTON-PRESSED will be good enough: ----assue your block name is "it_glaps_mc"

begin
----call the stored procedure first

      cancel(:it_glaps_mc.p_id);
---requery the underlying row from database

     go_block('it_gdaps_mc');
    :global.id:=:it_glaps_mc.p_id;
    set_block_property('it_gladps_mc', default_where, 'P_id=:global.id' );     execute_query;
    synchronize;
    set_block_property('it_gladps_mc', default_where, '1=1' );     erase('global.id');

end;

---------note: in SET_BLOCK_PROPERTY where clause, if you
-------- write like P_ID=:BLOCK_NAME.P_ID might not work, I found
---------using global variable or parameter is a sure way to make the query

"M Hamilton" <mhamilton_at_usgs.gov> wrote in message news:7ce65461.0311210914.76d73ddd_at_posting.google.com...
> Come on now, someone out there knows how to do this. I just know it.
> There's got to be a Forms expert that can help me out.
>
> How about Daniel Morgan? He seems to know alot and participates in
> this forum a bunch with innovative solutions.
>
> Help, pleezz.
> MH

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Mon Dec 01 2003 - 21:41:35 CET