Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB General
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
overriding generated keys on import
Tue, Sep 27 2016 5:00 PM
Permanent Link
Gregory T Swain
Zucchetti North America LLC
Attempting to import a table from another dbms.
Table has an identity column.
Table definition in Elevate has an identity column with 'generated always ...' This is what I want for normal use.
I wish to disable identity key generation on import, then re-enable it and set a new seed.
Am getting exception:
ElevateDB Error #1000 An error occurred with the cursor TableColumns (An attempt was made to update a read-only cursor)
Searches yield no means to fix or sidestep this.
Tue, Sep 27 2016 6:18 PM
Permanent Link
Gregory T Swain
Zucchetti North America LLC
Answered my own question: Alter Table.