home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,303 of 19,505   
   Gene Wirchenko to esquel@sommarskog.se   
   Re: SSE 2008: Handling Transaction Batch   
   06 May 11 15:06:54   
   
   From: genew@ocis.net   
      
   On Fri, 06 May 2011 23:46:56 +0200, Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>      I want to post batches of transactions.  The transactions have to   
   >> pass various checks.  The transaction must balance to zero.  Only   
   >> certain transaction type combinations will be allowed.  It must be   
   >> possible to modify a batch's transactions and have all of the   
   >> aforesaid checks done.   
   >>   
   >>      I see two ways to go about it.   
   >   
   >Unfortunately, this is a bit too vague to be able to say what might be   
   >the best. All I can say is that from the business domain I come from,   
   >updating transactions is a big no-no. You can cancel them, but you   
   >cannot modify them.   
   >   
   >But I suspect that this is just a made-up exercise you make for your   
   >training. So why not do both solutions, and see which one you like the   
   >best?   
      
        Not made up.  I may well use it.  I do not need auditing   
   capability.   
      
        Because if I did that every time I ran into an issue, I still   
   would not know what is the better *general* solution.  I want to know   
   that.  If a particular application is written less efficiently, that   
   is acceptable to me as long as I have a generally good method.  (I can   
   fine-tune later.)   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca