SQL Server

Get a Related Item as Text

Demonstrates the Chilkat Email.GetRelatedString method, which returns the text of a related item (with CR line-endings), interpreting the item's bytes using the supplied charset. It is intended for text-based related items such as style sheets. The first argument is the zero-based related-item index and the second is the charset. This example reads an embedded CSS style sheet as text.

Background: Not every related item is a binary image — some are text, like a CSS style sheet embedded so the HTML renders consistently offline. For those, GetRelatedString decodes the bytes back to characters using the charset you specify (typically utf-8). For binary related items such as images, read the raw data via the BinData-based accessor instead. This variant normalizes line endings to bare CR; use GetRelatedStringCrLf when you need CRLF.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    --  Demonstrates the GetRelatedString method, which returns the text of a related item (with
    --  CR line-endings), interpreting the bytes using the specified charset.  This is intended
    --  for text-based related items such as style sheets.  The index is zero-based.

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'Subject', 'GetRelatedString example'

    --  The HTML references a related style sheet by name (Content-Location).
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, '<html><head><link rel="stylesheet" href="styles.css"/></head><body>Styled.</body></html>'

    --  Add the related style sheet (index 0).
    EXEC sp_OAMethod @email, 'AddRelatedString2', NULL, 'styles.css', 'body { color: navy; }', 'utf-8'

    --  Get the first related item (index 0) as text, interpreting the bytes as utf-8.
    DECLARE @content nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetRelatedString', @content OUT, 0, 'utf-8'

    PRINT 'Related item 0 text: ' + @content

    EXEC @hr = sp_OADestroy @email


END
GO