Expert in DELPHI with MySQL Data Access Components (MyDAC)

Hi everyone, I'm using Delphi Tokyo 10.2 with MySQL Data Access Components (MyDAC) 10.2.4. 1- I have a Customers Table which is shared with 100 different users. Each user must retrieve one customer record from this table and contact him/her. The problem sometimes different users contact the same customer at the same time. I need the user when retrieving a customer and while this user showing this customer data, the other users can't access this customer record. 2- I'm using MyDAC stored procedure component and it can't detect EOF While Not [login to view URL] do Begin … [login to view URL]; End; It can't detect EOF, which means at the end, it keep showing the last record again and again and again …