Hi

I'm updating EDB from 2.03 to 2.08 ( XE2 UPD 4 )

i have any lock ( ghost ) problem.

Use : TEDBTable

I have found the problem :


open table1
open table2
open table3

Table 1  Edit Record 1
Table 2  Edit Record 2
Table 3  Edit Record 3

// 3 table at the same time !!!

Close table1
Close table2
Close table3


with edb 2.08 when i close the first table, record 1 is always locked

the lock are removed only when all 3 table are closed.




if i add before "close" this line :

if Table1.State = dsEdit then
  Table1.Cancel;

work all fine








Mauro Botta

Mauro,

<< with edb 2.08 when i close the first table, record 1 is always locked
>>

Are all 3 TEDBTable instances pointing to the same physical table, or
different physical tables ?

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I can confirm this using the same table.   The key to reproducing it is that
you have to have the KeepTableOpen propery of the EDBSession set to True.
If it's set to False, everything works as expected.

I've also sent a bit more detail to you by email.

--
---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Gift Card Processing - Now available in Atrex 13

Atrex Electronic Support Options:
Atrex Knowledgebase: http://support.atrex.com/KB/root.aspx
Email: support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------  

Terry,

<< I can confirm this using the same table.   The key to reproducing it is
that you have to have the KeepTableOpen propery of the EDBSession set to
True. If it's set to False, everything works as expected.

I've also sent a bit more detail to you by email. >>

Thanks, this is fixed for the next minor EDB release.

Tim Young
Elevate Software
www.elevatesoft.com