# ParameterList

**Detailed Description**

These parameters can be changed to configure optional settings. Please only change the parameters if you know what you are doing. The default parameters have been tested and are intended for best-practice use.

| Scope    | Name                             | Type  | Initial     | Comment                                                                                                                                       |
| -------- | -------------------------------- | ----- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------- |
| Constant | gc\_MySQL\_wClientFlag           | WORD  | 16#8601     | Used in: MySQL\_Open \| Desc: Client Flag \| Default: 16#8601                                                                                 |
| Constant | gc\_MySQL\_wExtClientFlag        | WORD  | 16#3        | Used in: MySQL\_Open \| Desc: Extended Client Flag (For More Information see documentation \| Default:                                        |
| Constant | gc\_MySQL\_dwMaxPackets          | DWORD | 1024        | Used in: MySQL\_Open \| Desc: Number of maximum bytes in a client packet \| Default: 1024                                                     |
| Constant | gc\_MySQL\_tConnTimeOut          | TIME  | TIME#10s0ms | Used in: MySQL\_Open, MySQL\_Close \| Desc: Timeout for Open and Close Process \| Default: 10 Sec                                             |
| Constant | gc\_MySQL\_iStatementMax         | INT   | 10          | Used in: MySQL\_Exec, MySQL\_Query \| Desc: Upper Bound of the arrSQLStatement \| Default: 10                                                 |
| Constant | gc\_MySQL\_iStatementLength      | INT   | 100         | Used in: MySQL\_Exec, MySQL\_Query \| Desc: Size in Bytes of the arrSQLStatement \| Default: 100                                              |
| Constant | gc\_MySQL\_xClearDataSet         | BOOL  | FALSE       | Used in: MySQL\_Query \| Desc: Clear Result Set before Use (Caution: needs a lot of cycles) \| Default: FALSE                                 |
| Constant | gc\_MySQL\_tReceiveResponseTime  | TIME  | TIME#50ms   | Used in: MySQL\_Query \| Desc: Wait time before processing received response data (Info: expand this value for slow Servers) \| Default: 50MS |
| Constant | gc\_MySQL\_dwMaxColumns          | DWORD | 25          | Used in: MySQL\_DataSet \| Desc: Number of maximum columns which can be processed \| Default: 25 columns                                      |
| Constant | gc\_MySQL\_dwMaxRows             | DWORD | 40          | Used in: MySQL\_DataSet \| Desc: Number of maximum rows which can be processed \| Default: 40 rows                                            |
| Constant | gc\_MySQL\_dwMaxRowSize          | DWORD | 500         | Used in: MySQL\_DataSet \| Desc: Maximum length in bytes of one row which can be processed \| Default: 500 bytes                              |
| Constant | gc\_MySQL\_dwTxBufferSize        | DWORD | 8000        | Used in: MySQL\_ConnectionString \| Desc: Transmit Buffer Size \| Default: 8000                                                               |
| Constant | gc\_MySQL\_dwRxBufferSize        | DWORD | 40000       | Used in: MySQL\_ConnectionString \| Desc: Receive Buffer Size \| Default 40000                                                                |
| Constant | gc\_MySQL\_bCharsetNumber        | BYTE  | 16#8        | Used in: MySQL\_GetStringValue \| Desc: Character Set \| Default: 16#08 for Latin1                                                            |
| Constant | gc\_MySQL\_dwMaxColumnNameLength | DWORD | 80          | Used in: \<PRIVATE> \| Desc: Maximum length of a column name in bytes \| Default: 80                                                          |