FormatBatchQuery

(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 Only.
Related to:	AddConnection \| BuildDelete \| BuildInsert \| BuildSelect \| BuildUpdate \| ConvertToDbDate \| ConvertToDbTime \| ConvertToDbTimeStamp \| ConvertToVTSDate \| ConvertToVTSTime \| ConvertToVTSTimeStamp \| CopyRecords \| DBDropList \| DBGridList \| ErrMessage \| ExecuteQuery \| ExecuteQueryCached \| FlushCache \| GetConnList \| ResultFormat \| StatsWin \| TableSynch \| Transaction \| TransactionCached
Format:	\ODBCManager\FormatBatchQuery( dbType, QueryArray, StartingElement, NumberOfElements)
Parameters:

dbType

Required numeric value, indicating the type of this DB connection.

DBType	Meaning
0	MS SQL
1	MS Access
2	Oracle
3	MySQL
4	SyBase

QueryArray

Required. SQL queries to be executed in a batch.

StartingElement

Required. Indicates which element in the array to begin at.

NumberOfElements

Required. Indicates the number of elements of the array that should be processed.

Comments:

This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above.
The return value is the batch query as a text string. 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.

The only way to ensure that a long running (or faulty) query does terminate is to set appropriate values for both the parameters ExecutionTimeout and UseDriverTimeout. Modules executing queries are designed to be run as launched modules and will remain active until complete.