| Navigation: SQL Driver Strings(General) >====== BINDCOLORDER ====== |    |
DRIVER('SQLDriver', '/BINDCOLORDER = [0 | 1 | 2]' )
(Valid for all drivers except Oracle)
When executing a SELECT statement the driver has to do the following:
1.Compile the SELECT statement
2.Bind memory locations for the columns to be returned
3.Bind memory locations for the WHERE clause
4.Executes the SELECT statement
5.Fetch the data
The order that these are executed is not completely fixed. The compile (Step 1) must be done first and the fetch (Step 5) last. However, the other three steps can be executed in any order.
If BINDCOLORDER is set to 0, the order is 1, 2, 3, 4, 5.
If BINDCOLORDER is set to 1, the order is 1, 3, 2, 4, 5.
If BINDCOLORDER is set to 2, the order is 1, 3, 4, 2, 5.
The default is 0 for all supported driver except MySQL, which has a default setting of 2.