data not write to disk immediately when TableDirect is False

From: Xie Bingpeng (xbp_at_teabird.com.cn)
Date: 11/26/03


Date: Wed, 26 Nov 2003 17:52:31 +0800

hi all:
  I using D7,Access2000 for test.
I using two TADOTable:ADOTable1 and ADOTable2(has no index), they
have same ConnectionString and TableName,ADOTable1.TableDirect:= False;
I Append a record to ADOTable1, then I Open ADOTable2 and
ADOTable2.RecordCount=0!
if I ShowMessage or call sleep(1000) before
ADOTable2.Open,ADOTable2.RecordCount=1. that is: when
ADOTable1.TableDirect:= False, ADOTable1.Post does not write data to disk
immediately. Is this ADO bug? how to resolve it?

  thanks.