ParameterList

Detailed description

These parameters can be changed to configure optional settings. Please change the parameters only if you know what you are doing. The default parameters are tested and 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: requires 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: increase this value for slow servers) | Default: 50 ms

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

Last updated