Hi,
The default database profile for NexusDB indicates SupportsAutoIncs=“False”. However, this causes problems with NexusDB versions at least since v4.00 (which is several years old) when working with the .NET version of DA. I had problems with this a while ago, and after tracking the issue, I realized this was the problem. I created a custom DataAsbstract.daConfig file in my project, and the problem was solved.
This is the profile I’m using:
<DatabaseProfiles>
<NexusDB QuotingIdentifiers='""'>
...
<GetLastAutoInc SQL="SELECT LASTAUTOINC as LastAutoInc FROM #DUMMY"
SupportsAutoIncs="True"/>
...
</NexusDB>
</DatabaseProfiles>
I think this is still the case in the latest version of DA, so I thought I’d report it.
Thanks,
Arturo.