Home Forums Persistence Data Sources Insert record with binary foreign key

  • This topic has 1 voice and 0 replies.
Viewing 0 reply threads
  • Author
    • #10770
      Levon BarkerLevon Barker

      This is a follow on from this ticket which was resolved.

      If I wanted to insert a record into CLInbound call which references the CLCallReason.id how would I format that insert?

      INSERT INTO cfsc111.dbo.CLInboundCall
      (…,reasonId, …)
      VALUES(…, convert(binary(32), ‘1C5AC69E4782494ABAE9FD43827126C9’), …)

      doesn’t work. I get

      SQL Error [8152] [22001]: String or binary data would be truncated.

      For greater context, I am trying to insert a CLInbound call record (the table is empty currently) to use as a transferCallId reference when making a SOAP call to notify the application server of an incoming call.


Viewing 0 reply threads
  • You must be logged in to reply to this topic.