Advertisement

04.23.2008 at 03:07AM PDT, ID: 23345897
[x]
Attachment Details

Applyupdates for ClientDataSet to MSSQL never succeeds

Asked by blarke in Delphi Programming, MS SQL Server

Tags: Delphi

While applying updates "applyupdates(0)" to tables in my local access-databases, used for storing temporary results, works well, I have so far not been able to apply updates to any table in my MSSQL databases. I have poAllowMultiRecordUpdates, I have tried both with and without mastersources enabled, I have tried for both tables with and without master-detail relationships, I have tried loading from both tables and queries, and keeping them open. No luck. Both connections are ADO, tables and queries are handled similar.

The applyupdates allows return the number of records I wanted to applyupdates to, e.g. "1", and no changes are committed.

Any preconditions for applyupdates to work with MSSQL that I should know about?Start Free Trial
 
Keywords: Applyupdates for ClientDataSet to MSS…
Title
1 A question about ApplyUpdates Method
2 ApplyUpdates
3 Exception not caught on ApplyUpdates…
4 transaction and commit
5 ADO and identity fields
6 Delayed ADO update
 
Loading Advertisement...
 
[+][-]04.23.2008 at 06:09AM PDT, ID: 21420218

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 07:43AM PDT, ID: 21421219

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.23.2008 at 10:40AM PDT, ID: 21423287

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.24.2008 at 01:06PM PDT, ID: 21434640

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.24.2008 at 01:16PM PDT, ID: 21434725

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.24.2008 at 01:46PM PDT, ID: 21434978

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.24.2008 at 06:16PM PDT, ID: 21436444

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Delphi Programming, MS SQL Server
Tags: Delphi
Sign Up Now!
Solution Provided By: reynaldio
Participating Experts: 3
Solution Grade: A
 
 
[+][-]04.25.2008 at 01:03AM PDT, ID: 21437675

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.25.2008 at 08:56AM PDT, ID: 21440780

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.25.2008 at 10:14AM PDT, ID: 21441429

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.26.2008 at 08:48AM PDT, ID: 21445871

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.05.2008 at 03:40AM PDT, ID: 21499007

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628