|
Home > Archive > MS SQL Server > August 2005 > Data Locking Method
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Data Locking Method
|
|
| Robert Lie 2005-08-30, 3:23 am |
| Dear All,
I have a receiving application. The app works like below:
1. The operator must key in the delivery notes of the truck at the
receiving offices
2. The operator scans each items within a truck at the warehouse.
After finish unloading the items of one delivery notes (of truck), I
want the operator at the warehouse can't add or delete items anymore.
So the reconciliation report won't be changed in the future.
Does anyone have any suggestion how to solve this problem?
Thanks
Robert Lie
| |
| Bud Y. Zer 2005-08-30, 1:23 pm |
| BEGIN TRANSACTION when the delivery is put on the truck for delivery.
COMMIT TRANSACTION when the deliver arrives at the warehouse and is put on
shelf.
"Robert Lie" <robert.lie24@gmail.com> wrote in message
news:emexYRTrFHA.2996@tk2msftngp13.phx.gbl...
> Dear All,
>
> I have a receiving application. The app works like below:
> 1. The operator must key in the delivery notes of the truck at the
> receiving offices
> 2. The operator scans each items within a truck at the warehouse.
>
> After finish unloading the items of one delivery notes (of truck), I want
> the operator at the warehouse can't add or delete items anymore.
> So the reconciliation report won't be changed in the future.
>
> Does anyone have any suggestion how to solve this problem?
>
> Thanks
>
> Robert Lie
| |
| jxstern 2005-08-30, 8:23 pm |
| On Tue, 30 Aug 2005 14:37:52 +0700, Robert Lie
<robert.lie24@gmail.com> wrote:
>I have a receiving application. The app works like below:
>1. The operator must key in the delivery notes of the truck at the
>receiving offices
>2. The operator scans each items within a truck at the warehouse.
>
>After finish unloading the items of one delivery notes (of truck), I
>want the operator at the warehouse can't add or delete items anymore.
>So the reconciliation report won't be changed in the future.
>
>Does anyone have any suggestion how to solve this problem?
Not really a data locking issue, it's more about application design, i
think.
J.
|
|
|
|
|