I have a scenario where I have to perform some checks on a sales order before it is added.
My stored procedure works fine, but when I try to add or update a User Defined Object, I get the following error:
[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the nvarchar value 'FC_ADDR' to data type int. (CINF)
FC_ADDR is the Object ID.
All object ID fields are nvarchar. I do not understand why the stored procedure is trying to convert the Object ID to int.
Nevertheless, I have tried to give the UDO a numeric Object ID, but I then get an error that the Object ID is invalid.
Is this a bug that needs to be reported, or is there a logical explanation?
Any assistance would be greatly appreciated.