BINDCOLORDER

Top  Previous  Next

 

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.