(ODBC Manager Library)
| Description: | Subroutine to convert 2-d array as returned from query in the form, Arr[Field][Rec], to a normalized format of Arr[Rec][Field]. For single record reads, this function returns a single dimension array Arr[N] where N is the number of fields. |
| Returns: | Array |
Usage:  |
Script Only. |
| Function Groups: | ODBC |
| Related to: | AddConnection | BuildDelete | BuildInsert | BuildSelect | BuildUpdate | ConvertToDbDate | ConvertToDbTime | ConvertToDbTimeStamp | ConvertToVTSDate | ConvertToVTSTime | ConvertToVTSTimeStamp | CopyRecords | DBDropList | DBGridList | ErrMessage | ExecuteQuery | ExecuteQueryCached | FlushCache | FormatBatchQuery | GetConnList | ResultFormatStatsWin | TableSynch | Transaction | TransactionCached |
| Format: |
\ODBCManager\ResultFormat( DataArray, MakeSingle ) |
| Parameters: |
| DataArray |
| Required. An array of fields and records to transpose |
| MakeSingle |
| Required. If true (1), and if the array size is 1 this indicates that the a single dimension array should be returned. |
| Comments: |
This module is a member of the ODBCManager Library, and must therefore be prefaced by \ODBCManager\, as shown in "Format" above. 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. |
