Record Update after change or insert
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
Less
More
7 years 10 months ago #13965
by julian.wallasch
Record Update after change or insert was created 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
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.
7 years 10 months ago #13966
by admin
Mike
ETL Architect
Replied by admin on topic Record Update after change or insert
What is the database you are working with?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
7 years 10 months ago #13967
by julian.wallasch
Replied by julian.wallasch on topic Record Update after change or insert
I'm working with SQL Server 2005.
Please Log in or Create an account to join the conversation.
7 years 10 months ago #13968
by admin
Mike
ETL Architect
Replied by admin on topic Record Update after change or insert
I doubt that it is possible but we will try
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
7 years 9 months ago #14074
by julian.wallasch
Replied by julian.wallasch on topic Record Update after change or insert
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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
7 years 9 months ago #14075
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Record Update after change or insert
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
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.