Re: problem about ADOTable+Grid

After insert in details table the record, updated this with values of
link fields from value of Master table record, execute post on detail
table and refresh table beacause for commit changes and after that
refresh on grid table of detail grid1.refresh.

Adrian Popa ( armitage49%40yahoo.com">armitage49yahoo.com)

--- In delphi-en%40yahoogroups.com">delphi-enyahoogroups.com, "Alex Oentoro&quot; <alexssby...> wrote:
&gt;
> I've already done it before, but the result still the same
>;
> procedure TForm1.TDetailNewRecord(DataSet: TDataSet);
> begin
&gt; With TDetail do
> begin
&gt; FieldValues['TNo'] := TMaster.FieldValues
['TNo'];
> FieldByName('TUrut').AsInteger := RecordCount + 1;
> FieldByName('TQty').AsInteger := 0;
> FieldByName('THrg').AsInteger := 0;
> FieldByName('TSubTot').AsInteger:= 0;
> end;
>; end;
>;
> On 2/6/07, Vishak <vishak...> wrote:
&gt; > Hi,
> > When you define a master-detail relationship between two datasets
(tables, in your case), the detail dataset is filtered according to
relationship field with master dataset. When you create a new record
in detail dataset, please check if you are setting the value of this
relation field according to current record in Master dataset.
> >
>; > E.g.
>; > OnNewRecord of detail u can mention
> > TDetail.FindField('TNo').AsString := TMaster.FindField
('TNo').AsString;
>; >
>; > HTH,
>; > regards,
> > Vishak
&gt; > ----------------------------------------------------
> > ----- Original Message -----
&gt; > From: Alex Oentoro
> > To: delphi-en%40yahoogroups.com">delphi-enyahoogroups.com
&gt; > Sent: Tuesday, February 06, 2007 9:44 AM
> > Subject: [delphi-en] problem about ADOTable&#43;Grid
&gt; >
>; >
>; > Hi,
> > i have a question about master-detail connection using TADOTable
& Grid
>; >
>; > I put 2 ADOTable in 1 form :
> > TMaster : Primary Key : TNo
> > TNo char(10)
> > TTgl date
>; > TCust char (25)
>; >
>; > TDetail : Primary Key : TNo, TUrut
&gt; > TNo char(10)
> > TUrut byte
>; > TBarang char(25)
> > THrg integer
> > TQty integer
> > TSubTot integer
> >
>; > TMaster & TDetail connected via MasterSource property of TDetail
> >
>; > each table connected to separate Grid
>; >
>; > the Problem occurs on the detail grid. Everytime I enter more
than 1
> > row, detail for the previous row become disappear. But after the
> > Transaction is saved, all data rows suddenly appear.
> > eq : I enter 1 row on detail, and then press down key to enter
data
> > for 2nd row on the grid ... then 1st row is disappear. Same thing
&gt; > happened when I press down once more to enter the 3rd data, so at
one
&gt; > time there is only 1 row appear in the detail grid
>; >
>; > what should I do to make all rows always appear when I enter more
than
> > 1 row of data ?
> >
>; > thx in advance.
>

Messages in this topic (5) Reply (via web post) | Start a new topic

.