Record Update after change or insert

More
7 years 10 months ago #13965 by julian.wallasch
Hi,

I'm using Version 5.3.1.19 of ATE.
I want to mention an issue, which exists for a long time:
After a record is inserted or updated in a table, you have to refresh the table to get the latest information. For example if there is some information from another table, that should be shown automatically in the record, you just inserted, you do not see this information until you refreshed.
So my question is: Can you implement, that the latest Information is shown immediately after an insert or update on a record? Is it possible, that you do not refresh the whole table for this? A refresh would change the record order after an insert.

Best Regards

Julian

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #13966 by admin
What is the database you are working with?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #13967 by julian.wallasch
I'm working with SQL Server 2005.

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #13968 by admin
I doubt that it is possible but we will try

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #14074 by julian.wallasch
Hi,

Is there something new regarding this topic?
I noticed that for the Administrator there already is an update like the one I asked for. It is in the Users table, if you are logged in as Administrator.
For example, if you type in an Email address in the properties and then switch to the field for the Company Name, the Email address is already updated in the table.

Best Regards

Julian

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #14075 by Peter.Jonson
1) I noticed that for the Administrator there already is an update like the one I asked for. It is in the Users table, if you are logged in as Administrator.
For example, if you type in an Email address in the properties and then switch to the field for the Company Name, the Email address is already updated in the table.

It looks like it is working the way you wanted it but it is not, we just using same dataset here

2) The only possible solution we found so far is this one

codeverge.com/embarcadero.delphi.ado/ref...om-tadoquery/1089138 .

and it is sort of half working EG it gives inconsistent results plus it does not work with insets

3) It not like we just do not want to help you or avoiding doing it for you, it is just not possible

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.