Lock error

classicmydac · Post by **classicmydac** » Fri 23 Dec 2005 12:05

Delphi7 Mysql5 latest Mydac registered

when I use datamodule7.Table_Customer.Lock(lrImmediately);

I get the error undeclared identifier 'lrImmediately'

Am I missing something here or being stupid.

I have just converted my app from Paradox tables to MySql5 tables.

Everything seems fine and a hell of alot quicker. I noticed that locking is not automatic so I have read the forums and added the above code on editing a table.

I am trying to lock the row I am editing.

Also what is the syntax to refresh a table in code.

Cheers

SteveW

Ikar · Post by **Ikar** » Fri 23 Dec 2005 13:48

> I get the error undeclared identifier 'lrImmediately'

Add MyAccess to uses list.

> am trying to lock the row I am editing.

Please see Lock demo for example.

> Also what is the syntax to refresh a table in code.

Use MyTable1.Refresh;