Programming i!-Database Plus
19
i!-Database Plus and DBWizard
RunDBQuery
Converts ADO RS to
XML.
The RunDBQuery function is used to convert record sets to XML.
Syntax:
RunDBQuery( strDBPath, strProvider )
Variables:
strDBPath = Represents the file path or DSN to the database. If the file has no path
included, the path is assumed to be local in the same directory as the ASP file.
(Required.)
strProvider = Represents the provider string for the database. No value is needed
for a DNS type connection. If the file contains ".mdb", a provider of
"Microsoft.Jet.OLEDB.4.0" is added to the one not provided. (Required.)
Return Values:
RunDBQuery returns an XML representation of a record set.
ErrorToXML
Converts error code
and descriptions to
XML.
The ErrorToXML function is used to convert errors to XML.
Syntax:
ErrorToXML(nNumber, strDesc)
Variables:
nNumber = Represents the error number. (Required.)
strDesc = Required. Represents the error description. (Required.)
Return Values:
XML representation of an error.
VariableHeader
Creates a variable
header (hungarian
notation) for a given
ADO variable type.
The VariableHeader is used to add the hungarian notation to field names so they
match the NetLinx variable definition designed to hold the data from a given field.
Syntax:
VariableHeader(ADOVarType)
Variables:
nADOVarType = Represents the ADO variable type. (Required.)
Return Values:
A string to add to the field name to create a NetLinx variable name.
