How to lock a record?

Author	Message
Edhy Rijo	E Edhy Rijo posted 15 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

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Edhy Rijo - 15 Years Ago

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

Trent L. Taylor - 15 Years Ago

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

Edhy Rijo - 15 Years Ago

This is really the best way. :)

Trent L. Taylor - 15 Years Ago

Hi Edhy,

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

Peter Jones - 15 Years Ago

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

Edhy Rijo - 15 Years Ago

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

Ger Cannoll - 13 Years Ago

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

Edhy Rijo - 13 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login