Please TeamB, I want your comment about this...

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Romulo Tue, 18 Dec 2001 15:35

#390

Author: Romulo
Date: Tue, 18 Dec 2001 15:35

12 lines
1463 bytes

Hi anyone or TeamB !!!!

I have a application running ok, but some times no work.
I have a TQuery - TDataSetProvider - TClientDataSet components, all ok with
TDataSetProvider->UpdateMode = upWhereAll, but when I want to optimize the
performance and do that :TDataSetProvider->UpdateMode = upWhereChanged I get
the following message : "Update affected more than 1 record" but I have only
one record editing, I have not a triggers or some thing similar.

Please, if any one to know what going on say to me!

Thanks.

Re: Please TeamB, I want your comment about this...

#391

Author: vavan
Date: Tue, 18 Dec 2001 16:19

13 lines
1460 bytes

On Tue, 18 Dec 2001 11:35:34 -0400, "Romulo" <rubenvive@hotmail.com>
wrote:

>TDataSetProvider->UpdateMode = upWhereAll, but when I want to optimize the
>performance and do that :TDataSetProvider->UpdateMode = upWhereChanged I get
>the following message : "Update affected more than 1 record" but I have only
>one record editing, I have not a triggers or some thing similar.

I believe you forgot to point which fields in your TQuery are key
fields..

--
Vladimir Ulchenko aka vavan

Re: Please TeamB, I want your comment about this...

#393

Author: MNV
Date: Wed, 19 Dec 2001 05:07

14 lines
1334 bytes

"Romulo" <rubenvive@hotmail.com> wrote in message news:3c1f543b$1_1@dnews...
> Hi anyone or TeamB !!!!
>
> performance and do that :TDataSetProvider->UpdateMode = upWhereChanged I
get
> the following message : "Update affected more than 1 record" but I have
only

You should use
TDataSetProvider- > UpdateMode = upWhereKeyOnly
And certainly, in the table there should be a primary key

( I apologize for bad English)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads