Hi Stephen,
You can only use the RetrieveAutoIncrementPK flag if the field is of type Integer and Identity is set to Yes. You can't set a default value for this kind of field.
>I found the answer to my question but I may have found a bug in the framework. The RetrieveAutoIncrementPK flag seems to be the answer to my question. However, when I set this flag to true, I am getting a NULL error.
>
>
>Cannot insert the value NULL into column 'irecversion',
>table 'aav3.dbo.AAName'; column does not allow nulls. INSERT fails.
>
>
>The field irecversion already have a default value of 0 set in the SQL Server. I should never get this particular error useless the INSERT command is actually sending NULL as the value of irecversion. BTW, when I set
>RetrieveAutoIncrementPK back to false, the insert works correctly.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi