> Keylinks are defined properly, and even the update statement
> generated in EditDSQL component is correct. The RowsEffected
> value is greater than 1, which is not correct, as only one record is
> updated (the updates are applied to database).

You could to try to put a tib_monitor in your form and see which sql
statements are being generated behind the scenes.

Luiz.

----- Original Message -----
From: "Sandeep" <sandeep@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, November 05, 2001 12:10 AM
Subject: Re: [IBO] Views


> On 4 Nov 2001, at 23:27, Luiz Alves wrote:
>
> > Sandeep,
> > > I can add record thru the view, but when I try to modify a record I
> > > get an exception multiple records updated. I don't know why it is
> > > doing that, any suggestions
> >
> > Perhaps, some problems with Keylinks not defined correctly.
>
> Keylinks are defined properly, and even the update statement
> generated in EditDSQL component is correct. The RowsEffected
> value is greater than 1, which is not correct, as only one record is
> updated (the updates are applied to database).
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>