This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I might have found why the sequence in Oracle is not synchronized with the value that Lightspeed is reading. Once you deploy a web application and lightspeed has never queried a sequence, it queries that sequence twice. Here this the output: SELECT SEQ_ADDRESS_ID.NEXTVAL FROM dual In this case, I reset the sequence SEQ_COMPLAINT_ID with the following script: DROP SEQUENCE TWIST.SEQ_COMPLAINT_ID; This happens only the first time. All the other times it queries the sequence number only once. Is this a bug?
|
|
|
Don't bother with this one. Refer to the other thread: http://www.mindscape.co.nz/forums/Thread.aspx?ThreadID=2238
|
|