(SQL Server) Get a Piece of Information from the LastErrorXml

Demonstrates how to get a bit of information from the LastErrorXml. Suppose you call ftp.DeleteRemoteFile and it fails, and the LastErrorXml property contains the XML as shown below. This example gets the content in the "statusCode" tag.

<ChilkatLog>
  <DeleteRemoteFile>
    <DllDate>Dec 30 2015</DllDate>
    <ChilkatVersion>9.5.0.55</ChilkatVersion>
    <UnlockPrefix>xxx</UnlockPrefix>
    <Username>CHILKAT:Matt</Username>
    <Architecture>Little Endian; 32-bit</Architecture>
    <Language>Visual C++ 11.0 (32-bit)</Language>
    <VerboseLogging>0</VerboseLogging>
    <filename>[does_not_exist.txt]</filename>
    <deleteFile>
      <simplePathCommand>
        <simpleCommand>
          <sendCommand>
            <sendingCommand>DELE does_not_exist.txt</sendingCommand>
          </sendCommand>
          <readCommandResponse>
            <replyLineQP>550 Delete operation failed.</replyLineQP>
          </readCommandResponse>
        </simpleCommand>
        <error>Simple path command failed.</error>
        <statusCode>550</statusCode>
        <reply>550 Delete operation failed.</reply>
      </simplePathCommand>
    </deleteFile>
    <error>Failed.</error>
  </DeleteRemoteFile>
</ChilkatLog>

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.



END
GO