I'm trying to figure out how to use MS SQLServer 2K's Identity columns as a
primary key, which automatically generate a new value for the field when
using Modular DB Actions to do an insert.
I kinda thought it should look like this for an identity column called "id"
in the database descriptor:
<key name="id" type="int" autoincrement="true">
<mode name="auto" type="autoincr"/>
</key>
But it didn't work.....the DatabasAddAction tried to insert the value for the
actual key, and SQLServer punted that since you can't manually set identity
columns.
Is it the <mode> above that is causing this behaviour?
Any hints as to how to set up the <key> section in the database descriptor
for this to work.
Thanks!
Andrzej Jan Taramina
Chaeron Corporation: Enterprise System Solutions
http://www.chaeron.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
