Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Not showing deleted records - how to set filterchanges FireDac issue?


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Apr 5, 2017 6:57 PM Last Post By: John MacDonald
John MacDonald

Posts: 179
Registered: 3/22/98
Not showing deleted records - how to set filterchanges FireDac issue?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 1, 2017 5:13 AM
Hello all: I am using Rad studio XE6 - C++ builder.

I understand that if I make changes to the filterchanges property that I am supposed to see my changelog.
I will need to see modified, inserted and even deleted- and turn off unmodified.

The issue : at "design time"
First chached updates has to be turned on or when I change the filterchanges property it throws an error.
So long as cached updates is already turned on there is no error when I change this property
after I make the change and run the compiler says "[FireDac][Comp][Clnt]-511. Dataset [qemploy] must be in cached update mode".

It seems to be in cached update mode or it would not change the filter.... how can it say it is not in update mode.
I don't understand.

--
JMAC out
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Not showing deleted records - how to set filterchanges FireDac issue?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 1, 2017 9:23 AM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
Hello all: I am using Rad studio XE6 - C++ builder.

I understand that if I make changes to the filterchanges property that I am supposed to see my changelog.
I will need to see modified, inserted and even deleted- and turn off unmodified.

The issue : at "design time"
First chached updates has to be turned on or when I change the filterchanges property it throws an error.
So long as cached updates is already turned on there is no error when I change this property
after I make the change and run the compiler says "[FireDac][Comp][Clnt]-511. Dataset [qemploy] must be in cached update mode".

It seems to be in cached update mode or it would not change the filter.... how can it say it is not in update mode.
I don't understand.

--
JMAC out

FilterChanges is a feature of cached updates. In non cached mode changes are
sent immediately to the backend so the delete or edit or whatever has already
happened so the filtering on that makes no sense anymore.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Not showing deleted records - how to set filterchanges FireDac issue?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 5, 2017 6:57 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Hello Jeff:

Thanks for your reply.
When part of the update fails, I know it never happens <grin>, won't I need to access the rtError?

What if I want to see the updates before I commit them?

I guess I could go through each of the records and check its status or
add a calculated field in and do a query on the calculated field?

John

Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
Hello all: I am using Rad studio XE6 - C++ builder.

I understand that if I make changes to the filterchanges property that I am supposed to see my changelog.
I will need to see modified, inserted and even deleted- and turn off unmodified.

The issue : at "design time"
First chached updates has to be turned on or when I change the filterchanges property it throws an error.
So long as cached updates is already turned on there is no error when I change this property
after I make the change and run the compiler says "[FireDac][Comp][Clnt]-511. Dataset [qemploy] must be in cached update mode".

It seems to be in cached update mode or it would not change the filter.... how can it say it is not in update mode.
I don't understand.

--
JMAC out

FilterChanges is a feature of cached updates. In non cached mode changes are
sent immediately to the backend so the delete or edit or whatever has already
happened so the filtering on that makes no sense anymore.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02