GenerateHTMLString 

Syntax

object.GenerateHTMLString  bIsMailResult,  bDescription,  bSQL,  bLogo, lpszHrefSite,  lpszHrefText,  lpszText

bIsMailResult - if True an extra Empty line is appended at the start and end of ELS-QB

           component generated output, so that the user may enter e-mail message before and after it.

bDescription - if True a section with the “Description”  header will be included into

         ELS-QB component generated output.

bSQL             - if True a section with the “SQL Command” header will be included into

         ELS-QB component generated output below which the SQL command text must be included.

bLogo            - if True ELS-QB component’s generated output will include ELS – LOGO as a footnote.

lpszHrefSite  -  a String representing URL address of hyperlink reference included in the ELS – LOGO.

lpszHrefText  - a String string representing the text of hyperlink reference included in the ELS – LOGO.

lpszText         - a String representing additional text information to be included in ELS – LOGO.

Description

Call this method to o obtain the contents of Result tab grid of  ELS-QB component in HTML format.

Remarks

GenerateHTMLString method returns a String, which represents the query result as HTML formatted text.

Example

This sample code shows how to generate the result of query as HTML string within  ELS-QB control.

Private Function itmCommandOutputAsHTML_Click()As String

    Dim sURL, sURLText, sText

    ' A string containing some URL address the end user

    ' would like to create a link to from generated HTML

    ' output, e.g.

    sURL = "www.microsoft.com"

    ' A string containing the text of hyperlink

    ' reference, e.g.

    sURLText = "www.microsoft.com"

    ' A string of Additional information to be included

    ' in the generated output, may be some Copywrite

    ' informtion, e.g.

    sURL = "Copyright © 2001 Microsoft, Inc."   

    Dim sHTMLOut

    sHTMLOut = ELS_QBCtrl.GenerateHTMLString( False, True, True, True, sURL, sURLText, sText)

    ' Do something with generated HTML string

    ...........

End Function