Adding a segment of text

Last updated:

    Overview

    This section explains how to add a section of text.

    Adding a segment of text

    Form 4.31 has a section which has different wording for sole or joint Liquidators:

    File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/030_Adding+a+segment+of+text/PDF_AddText1.png

    The pdf has been amended so that one field (“Appointed”) covers the text for the sole or joint options:

    File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/030_Adding+a+segment+of+text/PDF_AddText2.png

    The listing below selects “I was appointed” or “we were appointed” depending on whether one, or more than one, appointee is attached to the job.

    INSERT INTO @Data
    SELECT  'Appointed' ,
            CASE WHEN ( SELECT  COUNT(AppointmentTypeID)
                        FROM    dbo.Appointment
                        WHERE   ISNULL(Startdate, '') <> ''
                                AND ISNULL(Enddate, '') = ''
                                AND adminID = @AdminID
                      ) = 1 THEN ', I was appointed'
                 ELSE ', we were appointed'
            END