🚀 go-pugleaf

"John Moshakis" <john@moshakis.com> wrote in message
news:423b32b6$2@newsgroups.borland.com...
> Vagelis wrote:
>
> > Hello everybody.
> >
> > Is there any way I can insert a record in a detail table without
> > getting an "Invalid CurrentPageIndex value. It must be >= 0 and < the
> > PageCount" error?
> >
> > I have only found examples for master-detail tables, using
> > dbwebgrids, where the detail tables are always read only.
> >
> > Thanks in advance.
>
> Hi,
>
> What does your code look like?
>
> Cheers,
> John


Hi John.Thanks for the reply.

The Update and Delete rules in my relation have the "Cascade" value and the
Accept/Reject rule has "None".
After I set the relation properties from the relation editor of the dataset,
the code produced is:

Self.dataSet1.Relations.AddRange(TArrayOfSystem_Data_DataRelation.Create(Sys
tem.Data.DataRelation.Create('Relation1', 'Swmata', 'Swmata_Description',
TArrayOfString.Create('ID'), TArrayOfString.Create('SID'), False)));

Self.dataSet1.Tables.AddRange(TArrayOfSystem_Data_DataTable.Create(Self.Data
Table1,
          Self.DataTable2));

'ID' is the primary key of my master table 'Swmata' and 'SID' is the foreign
key used by the child table 'Swmata_Description.
The following steps are never executed but I include them so as you can
understand the strategy I try to follow.

In the ApplyChanges event of my dbWebDatasource my code is:

procedure TWebForm1.ApplyChanges(sender: System.Object; e:
Borland.Data.Web.WebControlEventArgs);
begin
    BdpDataAdapter1.AutoUpdate;
    BdpDataAdapter2.AutoUpdate;
end;

where BdpDataAdapter1 is used for the master table and BdpDataAdapter2 for
the detail.

The idea is that in the next step I would try to change the update command
in the rowupdating event, so as I can give the apropriate foreign key value
to the new record.But obviously there is something wrong with the way I
follow.

The problem is I'm new to .NET and I don't even know if what I want to do
can be done, using AutoUpdate commands. A general example of master detail
tables with both of the tables being editable would be very helpful.

kalimera and thanks in advance,
Vagelis.