How to lock a record?

Author	Message
Edhy Rijo	E Edhy Rijo posted 16 Years Ago Topic Details Share Topic
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	I have the need to update a field "InStockQty" with an accumulated value of "InStockQty + 100" or some other value. In VFP I used "RLOCK" to lock the record and make sure my update is done before allowing somebody else to update this field, now how can I do the same with SF/.NET/MS-SQL? Edhy Rijo
	Reply Like 0
Replies
Edhy Rijo	E Edhy Rijo posted 16 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Thanks Trent, I think I will go with the Transaction since I want to try to keep all logic at the BO level since part of this application will escalate to be a Web Application. Edhy Rijo
	Reply Like 0
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	This is really the best way.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Edhy Rijo - 16 Years Ago

OK, this can get to be a complex topic. However, there are in fact...

Trent L. Taylor - 16 Years Ago

Thanks Trent,
I think I will go with the Transaction since I want...

Edhy Rijo - 16 Years Ago

This is really the best way. :)

Trent L. Taylor - 16 Years Ago

Hi Edhy,

Not sure what the logic is here but don't forget...

Peter Jones - 16 Years Ago

Hi Peter,
Thanks for the advice, I really have not experience...

Edhy Rijo - 16 Years Ago

Hi Edhy. I realise this is a fairly old thread , but I have a similar...

Ger Cannoll - 14 Years Ago

Hi Gerard, In this particular case I decided to use a...

Edhy Rijo - 14 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login