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.
Call this method to o obtain the contents of Result tab grid of ELS-QB component in HTML format.
GenerateHTMLString method returns a String, which represents the query result as HTML formatted text.
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."
sHTMLOut = ELS_QBCtrl.GenerateHTMLString( False, True, True, True, sURL, sURLText, sText)
' Do something with generated HTML string