IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / Stateful.
Post #154,777
by admin
Picture of admin
5/12/04 9:35:34 AM
Reply
New Stateful.
Desktop applications.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #154,783
by drewk
Picture of drewk
5/12/04 9:45:45 AM
Reply
New Then the issue is multi-column constraints
Like I said, if changing the first column will cause it to be in violation of a constraint until the second (third, fourth, etc) columns are also changed, you can't commit the update until all columns are changed.

ie: Loan amount has to be lower that purchase amount. If you want to raise both values you have to raise the purchase amount first. This case can be handled easily by simply warning the user and making them change the other field first. But what about a case where you actually need to update two fields in the same transaction to maintain referential integrity?

This is only a problem in a situation with multi-column constraints, but I would avoid it anyway. Business rules can change, and constraints can be added to tables after the UI is built.
===

Implicitly condoning stupidity since 2001.
     Discussion topic: data-aware controls on forms - (admin) - (31) - May 11, 2004, 05:30:45 PM EDT
         How active? Context? - (ben_tilly) - (3) - May 11, 2004, 05:52:10 PM EDT
             Re: How active? Context? - (admin) - (2) - May 12, 2004, 08:59:22 AM EDT
                 Are you really asking why Access is a bad idea? -NT - (ben_tilly) - (1) - May 12, 2004, 09:50:20 AM EDT
                     Whoops. - (admin) - May 12, 2004, 09:51:30 AM EDT
         Bad idea. - (mmoffitt) - (18) - May 11, 2004, 05:53:04 PM EDT
             Implementation vs effect - (ben_tilly) - (17) - May 11, 2004, 06:37:19 PM EDT
                 Consider what goes on in most such setups. - (mmoffitt) - (12) - May 11, 2004, 11:46:05 PM EDT
                     Don't be sure about the surely - (ben_tilly) - (11) - May 12, 2004, 10:01:53 AM EDT
                         Re: Don't be sure about the surely - (admin) - (4) - May 12, 2004, 10:09:33 AM EDT
                             That I agree with - (ben_tilly) - (3) - May 12, 2004, 10:29:19 AM EDT
                                 Why more? - (admin) - (2) - May 12, 2004, 10:32:32 AM EDT
                                     Duplication of information - (ben_tilly) - (1) - May 12, 2004, 10:43:55 AM EDT
                                         Must depend on what you're doing. - (admin) - May 12, 2004, 11:06:48 AM EDT
                         I can't add much to what Scott said. - (mmoffitt) - (5) - May 12, 2004, 10:27:12 AM EDT
                             Then see my response to Scott - (ben_tilly) - (4) - May 12, 2004, 10:34:04 AM EDT
                                 I did. And how? - (mmoffitt) - (3) - May 12, 2004, 10:38:38 AM EDT
                                     Ah, good point - (ben_tilly) - (2) - May 12, 2004, 11:22:16 AM EDT
                                         Problem is rollback - (drewk) - (1) - May 12, 2004, 01:10:54 PM EDT
                                             That's only an argument for a wrapper - (ben_tilly) - May 12, 2004, 01:44:31 PM EDT
                 Er, what headaches? - (admin) - (3) - May 12, 2004, 09:11:56 AM EDT
                     Depends how you're set up - (ben_tilly) - (2) - May 12, 2004, 10:22:56 AM EDT
                         Re: Depends how you're set up - (admin) - (1) - May 12, 2004, 10:44:03 AM EDT
                             More moving parts - (ben_tilly) - May 12, 2004, 11:39:48 AM EDT
         always thought that all forms should be a view of the table - (boxley) - May 11, 2004, 05:55:46 PM EDT
         Depends on the kind of data - (ChrisR) - (2) - May 11, 2004, 06:12:07 PM EDT
             Mostly agree - (ben_tilly) - (1) - May 11, 2004, 07:05:09 PM EDT
                 Love 'impedance mismatch' ! - (Ashton) - May 12, 2004, 12:54:20 AM EDT
         You didn't specify stateful or stateless system - (drewk) - (2) - May 11, 2004, 06:42:23 PM EDT
             Stateful. - (admin) - (1) - May 12, 2004, 09:35:34 AM EDT
                 Then the issue is multi-column constraints - (drewk) - May 12, 2004, 09:45:45 AM EDT
         Neat idea, but marginal in practice - (JayMehaffey) - May 11, 2004, 06:53:20 PM EDT

s/\$lrpd_saying/This space intentionally left blank./g
90 ms