MS Dynamics NAV SQL insert into tables with AutoIncrement fields (version 3.2.88y)

If inserting new records into MS Dynamics NAV SQL tables with an AutoIncrement field and not having the field in the Field List, then an error was returned, that you cannot insert 0 into an identity field. This was because we supply default values for all fields that are not mapped.

We now exclude certain fields from adding these default values. For now the list contains the "timestamp" and "Dimension Value ID" fields. This list can be changed using the "NAVSQLSkipAddDefaultValueForFields" variable in the rapidi.cfg file used with the RapidiConnector.

version 3.2.88y (16-04-2014)

About the author

Michael Bock, Founder & CEO

Michael founded Rapidi on technological excellence, fantastic customer service and continuous improvement. A data integration specialist since 1987, he remains focused on creating technology that solves real business problems.

Comments

MS Dynamics NAV SQL insert into tables with AutoIncrement fields (version 3.2.88y)

About the author

Recent Posts

Posts by Tag

Find out more

Connect

LEGAL

MS Dynamics NAV SQL insert into tables with AutoIncrement fields (version 3.2.88y)

About the author

FOR YOUR CONVENIENCE, RECEIVE ARTICLES STRAIGHT TO YOUR INBOX

Recent Posts

Posts by Tag

Find out more

Connect

LEGAL