Master-detail: I see all the detail records if I append a detail record

Master-detail: I see all the detail records if I append a detail record

Post by Dari » Tue, 16 Oct 2007 22:41:11


Hi,

I'm using Delphi 2006 update 2, and I'm experiencing in certain
circumstances I'm not capable to reproduce (but rarely) the situation
you see in the object.

I'm using a TADOQuery (ADOQuery1) as master and a TADOTable
(ADOTable1) as a detail data source; so the attribute
ADOTable1.DataSource is set to dsADOQuery1 (the TDataSource for the
ADOQuery1 query), then ADOTable1.MasterFields it set to "Chiave" (the
integer link field), and ADOTable1.IndexFieldNames is set to
"Chiave;DataInizio" (the link field + a date field).

It seems that when I exec a ADOTable1.Append, under certain
circumstances I can see all the records of the ADOTable1 table. If I
close and reopen the program, all seems to be returned normal.

Has anynone experienced the same (or a similar) situation?

TIA

Dario