When replication was taking place and when we tried to enter records in ERP Package i.e Navision we faced the following error.
231,”21s01”,[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied values does not match table definition.
Can anybody help me in resolving this.Please mail to me at
ranjit246@.yahoo.co.in
Merge replication requires every table article to contain a uniqueidentifier column with rowguid property set. If one doesn't exist, we add it. This column does have a DEFAULT constraint defined, so if you specify column list when doing your insert, this rowguid column will be transparent to your application.
It's good practice to specify a column list for all insert statements, I'm guessing your application doesn't do this, which is why your app is failing.
|||Where do i make this change. I am using the DataSouce in VB DataViewGrid.
Please help
No comments:
Post a Comment