Re: Forms Help: commit 1 block on a 2 block form
Date: Fri, 19 Nov 1999 16:59:54 GMT
Message-ID: <813vlv$tnt$1_at_nnrp1.deja.com>
[Quoted] > 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.
Received on Fri Nov 19 1999 - 17:59:54 CET