Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages
Started by Romulo
Tue, 04 Sep 2001 14:02
TDataSetProvider PROBLEMS.
Author: Romulo
Date: Tue, 04 Sep 2001 14:02
Date: Tue, 04 Sep 2001 14:02
12 lines
1362 bytes
1362 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: TDataSetProvider PROBLEMS.
Author: Mark Cashman
Date: Tue, 11 Sep 2001 11:08
Date: Tue, 11 Sep 2001 11:08
12 lines
1368 bytes
1368 bytes
Hi, Romulo! Can you tell us what DBMS you are using? Also, are you updating a join? ------ Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at http://www.temporaldoorway.com - Original digital art, writing, music and more - C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring (Join us!) http://www.temporaldoorway.com/programming/index.htm ------
Re: TDataSetProvider PROBLEMS.
Author: Romulo
Date: Mon, 17 Sep 2001 15:58
Date: Mon, 17 Sep 2001 15:58
31 lines
2020 bytes
2020 bytes
My DBMS is InterBase 6. And I am not use a Join. When a I use a TDataSetProvider = upWhereChanged some times work ok with someone fields, but with another fields in the same record not work. This fields with not work are not a key fields in the table, and the table have not a trigger. Really somethink are happening with this, but I don't know what is it. Thanks again. Bye. "Romulo" <rubenvive@hotmail.com> escribi� en el mensaje news:3b94fd1b_1@dnews... > 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: TDataSetProvider PROBLEMS.
Author: Romulo
Date: Mon, 17 Sep 2001 16:03
Date: Mon, 17 Sep 2001 16:03
32 lines
1970 bytes
1970 bytes
My DBMS is InterBase 6. And I am not use a Join. When a I use a TDataSetProvider = upWhereChanged some times work ok with someone fields, but with another fields in the same record not work. This fields with not work are not a key fields in the table, and the table have not a trigger. Really somethink are happening with this, but I don't know what is it. Thanks again. Bye. "Romulo" <rubenvive@hotmail.com> escribi� en el mensaje news:3b94fd1b_1@dnews... > 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. > >
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