|
|
Posted by Jerry Stuckle on 09/18/05 15:45
PRESENT321@gmail.com wrote:
> Quoting Jerry:
>
> Short answer: yes, I have used transactional processing. But only a
> minimal amount.
> Something like:
> Insert junk into orders;
> SELECT MAX(ID) AS OrderID from orders;
> Wrapped in a transaction.
>
There is a lot more to transactional programming than this.
For instance - how to you handle updating a record? I.E. a guy checks
his checking account balance and finds they has $500 in the account.
So, he decide to transfer $300 to savings - so he does it. But between
the time he checked his balance and he transferred the money, his wife
got $300 from the ATM. He is now overdrawn.
> If two orders go in spectacularly close, the transaction will still
> work properly.
> I'm sure I have much more reading on the subject :-)
>
It's more than just reading. It's something which takes experience.
> Does anyone have any suggestions for learning more on the subject?
>
> Matthew
>
You really need to get some experience in the banking world, ideally by
working as part of a team where you can learn the ins and outs of what's
required.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|