ChrisWalker90
Programmer
Hiya All
I'm trying to transfer the device table from SC to a SQL Server db and I'm getting errors around reconciliation.
Connect-it keeps trying to add the record to SQL Server instead of updating it therefore it errors as I've set a primary key in SQL, I think the problem is around reconciliation any ideas???
I've already set reconciliation to update or insert but the Connect-It scenario only trys to add the record not update it. I think I'm probably missing something any ideas?
Also do any of you know what this error message means?...
Line 1:syntax error '=';'=' should be Select_field
This occurs when I try and set logical.name as a reconciliation key!
Cheers
Chris
I'm trying to transfer the device table from SC to a SQL Server db and I'm getting errors around reconciliation.
Connect-it keeps trying to add the record to SQL Server instead of updating it therefore it errors as I've set a primary key in SQL, I think the problem is around reconciliation any ideas???
I've already set reconciliation to update or insert but the Connect-It scenario only trys to add the record not update it. I think I'm probably missing something any ideas?
Also do any of you know what this error message means?...
Line 1:syntax error '=';'=' should be Select_field
This occurs when I try and set logical.name as a reconciliation key!
Cheers
Chris