(ODBC Manager Library)
Description: When given an array of SQL queries, this module will re-format them into a single query, suitable for a batch call to the specified database.
Returns: Text
Usage: Script
Format: \ODBCManager\FormatBatchQuery( dbType, QueryArray, StartingElement, NumberOfElements)
Parameters: dbType { numeric } { required } { no default: }
Indicates the database type for use in selecting the appropriate separator string. . Refer to Database Type Codes used in the ODBC Manager for a list of the flags.
QueryArray { array of text } { required } { no default: }
SQL queries to be executed in a batch.
StartingElement { numeric } { required } { no default: }
Indicates which element in the array to begin at.
NumberOfElements { numeric } { required } { no default: }
Indicates the number of elements of the array that should be processed.
Returns: Returns the batch query as a text string
Comments: This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.
If the database type is unknown, this function will return only one element from the array, as indicated by the StartingElement. Batch queries cannot be created without knowing which separator string to use.