Margot Hoekstra
New Member
Hi!
Maybe somebody has a better idea or has a suggestion how to do the following:
I have two progress systems running. 1 is from an external vendor (in this example called 1), the other is ours (in this example called 2). We need to update database 2 with all the data which is used in a table used by the system 1 on a daily base. We only allowed to change the create trigger on that table in system 1. The table in system 1 will never be updated or deleted.
When a record is created in system 1 and i have only access to the create trigger, the only thing i have is the recid. So, i want to write the recid in the other database and when every user is ready with system 1, read the records i need to load in system 2 with the recid and after processing delete the entry where the recid is stored.
This will be a daily process because the table is very big in system 1 and i need all the records created on that day.
Is there anybody who has a better suggestion or has a suggestion how to store the recid in database 2 (as recid, as character or as decimal)?
Thanks!
Maybe somebody has a better idea or has a suggestion how to do the following:
I have two progress systems running. 1 is from an external vendor (in this example called 1), the other is ours (in this example called 2). We need to update database 2 with all the data which is used in a table used by the system 1 on a daily base. We only allowed to change the create trigger on that table in system 1. The table in system 1 will never be updated or deleted.
When a record is created in system 1 and i have only access to the create trigger, the only thing i have is the recid. So, i want to write the recid in the other database and when every user is ready with system 1, read the records i need to load in system 2 with the recid and after processing delete the entry where the recid is stored.
This will be a daily process because the table is very big in system 1 and i need all the records created on that day.
Is there anybody who has a better suggestion or has a suggestion how to store the recid in database 2 (as recid, as character or as decimal)?
Thanks!