topic Re: DB Connect Rising Column in Getting Data In

DB Connect Rising Column

xisura — Wed, 04 Dec 2013 09:33:08 GMT

Hi Everyone,

Im having a problem right now ,tail in db connect is not working, Does the rising_column needs to be unique ?

Please Help..

Thanks in Advance,
xisura

Re: DB Connect Rising Column

gfuente — Wed, 04 Dec 2013 10:04:53 GMT

Yes

It must be somthing like a timestamp or a auto increasing value that keeps rising, so db connect has a flag that identifies until which point the data has been indexed, and from that point index the new data every time the sql query is executed.

Regards

Re: DB Connect Rising Column

xisura — Mon, 28 Sep 2020 15:24:51 GMT

the problem is the db dont have rising_column,the customer just gave a query to use SELECT GETDATE() AS Server_Time ,name from information,the server_time will be the rising_column,everytime i run the query all the server_time column is the same, but if you run it again it will give you a different time, ex.i run it 6:36pm all the 1000rows server_time result will be 6:36pm,does the rising column needs to be in the database??

Re: DB Connect Rising Column

aelliott — Wed, 04 Dec 2013 15:21:10 GMT

Do they give you an Identity field such as "ID"?, i believe it needs to be in that table or a combination of fields that are equivalent to a number or date that would be unique per record.

Re: DB Connect Rising Column

xisura — Fri, 06 Dec 2013 04:45:22 GMT

they dont have that , also rows are not increasing , it will just find the name and update it , they also dont have lastupdate column