Retrieve new values of a database
Hello, I have the view from a table that keeps incrementing with new values, I have no control of this database, but I need to retrieve the new values to insert it on my table (sql server) and send some parameters of the database to another application, I'm using C# to get access to both databases, so does anybody know of an efficient way to retrieve only the new values of the dtabase? Thanks a lot Luis Saavedra
On 2 Oct 2006 15:58:23 -0700, "luissol" <luissol@gmail.com> wrote: >Hello, I have the view from a table that keeps incrementing with new >values, I have no control of this database, but I need to retrieve the >new values to insert it on my table (sql server) and send some >parameters of the database to another application, I'm using C# to get >access to both databases, so does anybody know of an efficient way to >retrieve only the new values of the dtabase? > Is it possible to put an insert trigger on this table? JWC
No, because I have no control over the Informix database, they have an ID for each registry, the problem is that not all the times it is sequential, for example they have 1 2 4 5 6 3 (not in order) 7 8 10 9 (not in order) what I have considered is using a counter in a table of my database, then use a count of all the registers of the informix table and get a top (of the difference between these two tables), the problem is that if in the lapse between the count and the selection of the registers they insert something in the table of informix, I will be missing some values, any ideas to solve this or use another solution... Thanks Luis Saavedra John Carlson wrote: > On 2 Oct 2006 15:58:23 -0700, "luissol" <luissol@gmail.com> wrote: > > >Hello, I have the view from a table that keeps incrementing with new > >values, I have no control of this database, but I need to retrieve the > >new values to insert it on my table (sql server) and send some > >parameters of the database to another application, I'm using C# to get > >access to both databases, so does anybody know of an efficient way to > >retrieve only the new values of the dtabase? > > > > Is it possible to put an insert trigger on this table? > > JWC