Hi,
I'm running sap db 7.3.0.15 on Windows 2000.
I created a table like this:
CREATE TABLE tab_test (
test_id INTEGER NOT NULL DEFAULT SERIAL (10000),
text VARCHAR(255) NOT NULL DEFAULT '-',
PRIMARY KEY(test_id)
);
And inserted Data like that:
INSERT INTO tab_test VALUES(DEFAULT,'blib')
OK
all fine, as expected.
But after a reboot I can not insert data anymore like that
because:
INSERT INTO tab_test VALUES(DEFAULT,'blib')
Native error: 200
Text: [SAP AG][SQLOD32 DLL][SAP DB]Integrity constraint violation;200 POS(1)
Duplicate key.
Wow. Does sapdb reset the SERIAL fields after reboot?
Regards, Axel
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
