Archive
Highlighted

DB Connect Rising Column

Communicator

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

Tags (2)
Highlighted

Re: DB Connect Rising Column

Motivator

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

0 Karma
Highlighted

Re: DB Connect Rising Column

Communicator

the problem is the db dont have risingcolumn,the customer just gave a query to use SELECT GETDATE() AS ServerTime ,name from information,the servertime will be the risingcolumn,everytime i run the query all the servertime 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 servertime result will be 6:36pm,does the rising column needs to be in the database??

0 Karma
Highlighted

Re: DB Connect Rising Column

Motivator

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.

0 Karma
Highlighted

Re: DB Connect Rising Column

Communicator

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

0 Karma