Options property
|
Previous Top Next |
Delphi/Kylix
|
MySQL
|
Description
|
coLongPassword
|
CLIENT_LONG_PASSWORD
|
New more secure passwords
|
coFoundRows
|
CLIENT_FOUND_ROWS
|
Return the number of found (matched) rows, not the number of affected rows.
|
coLongFlag
|
CLIENT_LONG_FLAG
|
Get all column flags
|
coConnectWithDB
|
CLIENT_CONNECT_WITH_DB
|
One can specify db on connect
|
coNoSchema
|
CLIENT_NO_SCHEMA
|
Don't allow database.table.column
|
coCompress (see Compression property)
|
CLIENT_COMPRESS
|
Use compression protocol.
|
coODBC
|
CLIENT_ODBC
|
The client is an ODBC client. This changes mysqld to be more ODBC-friendly.
|
coLocalFiles
|
CLIENT_LOCAL_FILES
|
Enable LOAD DATA LOCAL handling.
|
coIgnoreSpace
|
CLIENT_IGNORE_SPACE
|
Allow spaces after function names. Makes all functions names reserved words.
|
coInteractive
|
CLIENT_INTERACTIVE
|
Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable will be set to the value of the session interactive_timeout variable.
|
|
|
|
coSSL
|
CLIENT_SSL
|
If you have compiled the MyComponents using the HAVE_SSL directive (see the product.inc file in the source directory) then you will have this option available. You must now also have the OpenSSL libeay32.dll and ssleay32.dll libraries available to your application and system and may specify the key, ca, etc paths using the Params property of the TMySQLServer.
|
coIgnoreSigpipe
|
CLIENT_IGNORE_SIGPIPE
|
IGNORE sigpipes
|
coTransactions
|
CLIENT_TRANSACTIONS
|
Client knows about transactions
|
coProtocol41
|
CLIENT_PROTOCOL_41
|
New 4.1 protocol
|
coSecureConnection
|
CLIENT_SECURE_CONNECTION
|
New 4.1 authentication
|
coMultiQueries
|
CLIENT_MULTI_QUERIES
|
Tell the server that the client may send multi-row-queries (separated with ';'). If this flag is not set, multi-rowqueries are disabled. New in 4.1.
|
soAutoCreate
|
|
This option differs in that it has nothing to do with the initial connection. If set to True this will recreate you database and all attached table structures (which also doAutoCreate set) on the MySQL server when the TMySQLServer connects, see CreateDatabase for more info. NOTE: You may wish to disable this option after the database has been recreated successfully, otherwise this create script will be executed everytime the TMySQLServer connects. Because it uses "IF NOT EXISTS" SQL this won't cause any harm, but it is additional work to be done by both your application and the mysql server.
|
soDropIfExists
|
|
If doAutoCreate is enabled and this setting is enabled the compiled sql will be prefixed with a "drop database if exists.." statement. This setting is also used with the CreateDatabase method. WARNING: Be very, very careful with this option, if it is enabled on an existing database and the TMySQLServer is activated, even just at designtime you will lose all tables and data in this database.
|
soCloseOnChildren
|
|
If enabled, this will automatically disconnect the TMySQLServer if and when all children have closed.
|