Extracting data

Last modified

Overview

This section shows you how to extract data from the information held about a job in the application.

Extracting data

In this example, a telephone number is extracted from General > Addresses > Numbers.  Form HR1 requires the telephone number of the company to be provided:

File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/010_Extracting+data/PDF_ExtractData.png

The following listing shows an example script to extract this information:

INSERT  INTO @Data
SELECT  'Employers telephone number', n.Number
FROM    Admin_Number an 
        INNER JOIN Number n ON an.NumberID = n.NumberID 
        INNER JOIN NumberType nt ON n.NumberTypeID = nt.NumberTypeID
WHERE   (nt.NumberTypeID = 1) AND (an.AdminID = @AdminID)
Page statistics
278 view(s) and 4 edit(s)
Social share
Share this page?

Tags

CCH Insolvency

Comments

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |