Subject Re: [IBO] Can not edit/remove on dataset.
Author Jason Wharton
It is probably necessary to have columns from both tables in the key links
if it is an inner join and not a one-to-one relationship between them.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <>
Sent: Friday, June 29, 2001 2:15 AM
Subject: Re: [IBO] Can not edit/remove on dataset.

> Don Schoeman wrote:
> >I've already tried it that way around also which then allows you to
> >insert/edit/remove records, but then the posting of the new record fails
> >with a "multiple rows returned in singleton select" error. I think the
> >KeyLinks property should be set to TEAMS.TEAM_ID but like Jason said, I
> >probably have to write my own EditSQL and DeleteSQL statements.
> Huh?
> How can it be correct to have the KeyLinks and KeyRelation refer to
> different datasets? Since TEAM_ID is the primary key of TEAMS, I think
> SCHEDULE.MATCH_NO (the primary key for SCEDULE) would be the field
> identifying each record. I cannot see why you need your own EditSQL or
> DeleteSQL for this one - that is, unless you want to be able to modify
> of the TEAMS fields.
> Set
> Your use of Yahoo! Groups is subject to