Re: Forms Help: commit 1 block on a 2 block form
From: Peter Kolton <kolton_at_nospam.kolton.karoo.co.uk>
Date: Sun, 21 Nov 1999 21:24:23 -0000
Message-ID: <819o5u$ia2$1_at_supernews.com>
Date: Sun, 21 Nov 1999 21:24:23 -0000
Message-ID: <819o5u$ia2$1_at_supernews.com>
I did think of suggesting some hacked together code to do this, but I suspect it's not necessary - it usually isn't.
If we know what Tse is actually trying to do with his form then I'm sure someone can suggest a much easier and correct solution.
-- ======================================================== Pete Kolton ORACLE Systems Consultant All reasonable offers considered :-) Pete_at_kolton.com http://www.kolton.com ======================================================== <rtproffitt_at_my-deja.com> wrote in message news:813vlv$tnt$1_at_nnrp1.deja.com...Received on Sun Nov 21 1999 - 22:24:23 CET
>
> > Tse wrote in message <812j3v$ufb$1_at_nnrp1.deja.com>...
> > >i want to be able to commit the records in each of these tables
> > >separately. When I press F10 while at Head_block, i want only
> tab_head
> > >table to be commited and vice versa.
> > >
>
> If it is absolutely essential that this be done, then
> I think there is a way... but it would be extremely messy,
> and poor form.
>
> You could separate the Form from the data by using
> control blocks only. Then you would have to perform
> all SQL with DML statements. Further, you would have to
> remember all the work and perform it at button-press time,
> since, if the work were performed randomly, then any COMMIT
> would commit ALL the work, as Pete has said.
> Additionally, the only way to get the COMMIT to work would
> be to push it into a Stored Procedure, because the
> front end would say "Nothing to commit".
> This is generally bad, because you are risking de-synchronizing
> the back-end and the front-end.
> (we did it in one case where we were certain of the results:
> the very next step after commit was to exit the module back
> to calling module which performed a refresh, guaranteeing
> that the front-end would catch up)
>
> Most of the time, I would think there is a better way
> to re-organize the problem to use Forms wisely.
> ....but hey, there's a little bit of "hack" in
> every one of us. ;-)
>
> You can sign me "Bob the Hack" on this one.
>
> Robert Proffitt
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.