Jump to content
We have recently updated our Privacy Statement, available here ×

Orders upsert with null salesorderid failing

Recommended Posts

Hi All,


I'm attempting to use an upsert command in creating an Order, I have the GUID properly defined for existing orders, but when I attempt to pass NULL to it to create a new order, it returns 'Object reference not set to an instance of an object.'. The database itself is storing null as the value for new orders, however, I'm also adding a IF(ISNULLOREMPTY(orderid),NULL,orderid) ... I've tried changing NULL to "" as well, but that failed.

Link to comment
Share on other sites

  • Create New...