SELECT ..... FOR UPDATE? How to check it?

SELECT ..... FOR UPDATE? How to check it?

Postby dutch » Mon Jul 02, 2018 9:08 am

Dear All,

I would like to know how to check the SELECT .... FOR UPDATE (Record Lock).
1. Program will freeze until the first lock is :end()
2. Lock Column (flag) is not certain correct. Because, if the user which for FOR UPDATE quit. The column flag still "lock" status.

What is the solution like Rlock()?

Regards,
Dutch
Regards,
Dutch

FWH 19.01 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio
FWPPC 10.02 / Harbour for PPC (FTDN)
ADS V.9 / MySql / MariaDB
R&R 12 Infinity / Crystal Report XI R2
(Thailand)
User avatar
dutch
 
Posts: 1548
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 49 guests