Data Locking Method

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

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

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.