diff options
Diffstat (limited to 'doc/src/sql')
| -rw-r--r-- | doc/src/sql/sql-programming/qsqldatatype-table.qdoc | 708 | ||||
| -rw-r--r-- | doc/src/sql/sql-programming/sql-driver.qdoc | 108 | ||||
| -rw-r--r-- | doc/src/sql/sql-programming/sql-programming.qdoc | 36 |
3 files changed, 426 insertions, 426 deletions
diff --git a/doc/src/sql/sql-programming/qsqldatatype-table.qdoc b/doc/src/sql/sql-programming/qsqldatatype-table.qdoc index bc1c8b3c13..a7e03cf28f 100644 --- a/doc/src/sql/sql-programming/qsqldatatype-table.qdoc +++ b/doc/src/sql/sql-programming/qsqldatatype-table.qdoc @@ -48,518 +48,518 @@ \table 90% \header - \o IBM DB2 data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li IBM DB2 data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o SMALLINT - \o 16-bit signed integer - \o typedef qint16 + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 \row - \o INTEGER - \o 32-bit signed integer - \o typedef qint32 + \li INTEGER + \li 32-bit signed integer + \li typedef qint32 \row - \o BIGINT - \o 64-bit signed integer - \o typedef qint64 + \li BIGINT + \li 64-bit signed integer + \li typedef qint64 \row - \o REAL - \o 32-bit Single-precision floating point - \o By default mapping to QString + \li REAL + \li 32-bit Single-precision floating point + \li By default mapping to QString \row - \o DOUBLE PRECISION - \o 64-bit Double-precision floating point - \o By default mapping to QString + \li DOUBLE PRECISION + \li 64-bit Double-precision floating point + \li By default mapping to QString \row - \o FLOAT - \o 64-bit Double-precision floating point - \o By default mapping to QString + \li FLOAT + \li 64-bit Double-precision floating point + \li By default mapping to QString \row - \o CHAR - \o Fixed-length, null-terminated character string - \o Mapped to QString + \li CHAR + \li Fixed-length, null-terminated character string + \li Mapped to QString \row - \o VARCHAR - \o Null-terminated varying length string - \o Mapped to QString + \li VARCHAR + \li Null-terminated varying length string + \li Mapped to QString \row - \o LONG VARCHAR - \o Not null-terminated varying length character string - \o Mapped to QString + \li LONG VARCHAR + \li Not null-terminated varying length character string + \li Mapped to QString \row - \o BLOB - \o Not null-terminated varying binary string with 4-byte string + \li BLOB + \li Not null-terminated varying binary string with 4-byte string length indicator - \o Mapped to QByteArray + \li Mapped to QByteArray \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o DATE - \o Null-terminated character string of the following format: + \li DATE + \li Null-terminated character string of the following format: yyyy-mm-dd - \o Mapped to QDate + \li Mapped to QDate \row - \o TIME - \o Null-terminated character string of the following format: hh.mm.ss - \o Mapped to QTime + \li TIME + \li Null-terminated character string of the following format: hh.mm.ss + \li Mapped to QTime \row - \o TIMESTAMP - \o Null-terminated character string of the following format: yyyy-mm-dd-hh.mm.ss.nnnnnn - \o Mapped to QDateTime + \li TIMESTAMP + \li Null-terminated character string of the following format: yyyy-mm-dd-hh.mm.ss.nnnnnn + \li Mapped to QDateTime \endtable \section2 Borland InterBase Data Types \table 90% \header - \o Borland InterBase data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li Borland InterBase data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o BOOLEAN - \o Boolean - \o bool + \li BOOLEAN + \li Boolean + \li bool \row - \o TINYINT - \o 8 bit signed integer - \o typedef qint8 + \li TINYINT + \li 8 bit signed integer + \li typedef qint8 \row - \o SMALLINT - \o 16-bit signed integer - \o typedef qint16 + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 \row - \o INTEGER - \o 32-bit signed integer - \o typedef qint32 + \li INTEGER + \li 32-bit signed integer + \li typedef qint32 \row - \o BIGINT LONG - \o 64-bit signed integer - \o typedef qint64 + \li BIGINT LONG + \li 64-bit signed integer + \li typedef qint64 \row - \o REAL FLOAT - \o 32-bit floating point - \o By default mapping to QString + \li REAL FLOAT + \li 32-bit floating point + \li By default mapping to QString \row - \o FLOAT - \o 64-bit floating point - \o By default mapping to QString + \li FLOAT + \li 64-bit floating point + \li By default mapping to QString \row - \o DOUBLE - \o 64-bit floating point - \o By default mapping to QString + \li DOUBLE + \li 64-bit floating point + \li By default mapping to QString \row - \o DOUBLE PRECISION - \o 64-bit Double-precision floating point - \o By default mapping to QString + \li DOUBLE PRECISION + \li 64-bit Double-precision floating point + \li By default mapping to QString \row - \o VARCHAR STRING - \o Character string, Unicode - \o Mapped to QString + \li VARCHAR STRING + \li Character string, Unicode + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o DATE - \o Displays date. Format: 'yyyy-mm-dd' - \o Mapped to QDate + \li DATE + \li Displays date. Format: 'yyyy-mm-dd' + \li Mapped to QDate \row - \o TIME - \o Displays time. Format is 'hh:mm:ss' in 24-hour format - \o Mapped to QTime + \li TIME + \li Displays time. Format is 'hh:mm:ss' in 24-hour format + \li Mapped to QTime \row - \o TIMESTAMP - \o Displays a timestamp. Format is 'yyyy-mm-dd hh:mm:ss' - \o Mapped to QDateTime + \li TIMESTAMP + \li Displays a timestamp. Format is 'yyyy-mm-dd hh:mm:ss' + \li Mapped to QDateTime \endtable \section2 MySQL Data Types \table 90% \header - \o MySQL data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li MySQL data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o TINYINT - \o 8 bit signed integer - \o typedef qint8 + \li TINYINT + \li 8 bit signed integer + \li typedef qint8 \row - \o TINYINT UNSIGNED - \o 8 bit unsigned integer - \o typedef quint8 + \li TINYINT UNSIGNED + \li 8 bit unsigned integer + \li typedef quint8 \row - \o SMALLINT - \o 16-bit signed integer - \o typedef qint16 + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 \row - \o SMALLINT UNSIGNED - \o 16-bit unsigned integer - \o typedef quint16 + \li SMALLINT UNSIGNED + \li 16-bit unsigned integer + \li typedef quint16 \row - \o INT - \o 32-bit signed integer - \o typedef qint32 + \li INT + \li 32-bit signed integer + \li typedef qint32 \row - \o INT UNSIGNED - \o 32-bit unsigned integer - \o typedef quint32 + \li INT UNSIGNED + \li 32-bit unsigned integer + \li typedef quint32 \row - \o BIGINT - \o 64-bit signed integer - \o typedef qint64 + \li BIGINT + \li 64-bit signed integer + \li typedef qint64 \row - \o FLOAT - \o 32-bit Floating Point - \o By default mapping to QString + \li FLOAT + \li 32-bit Floating Point + \li By default mapping to QString \row - \o DOUBLE - \o 64-bit Floating Point - \o By default mapping to QString + \li DOUBLE + \li 64-bit Floating Point + \li By default mapping to QString \row - \o CHAR - \o Character string - \o Mapped to QString + \li CHAR + \li Character string + \li Mapped to QString \row - \o VARCHAR - \o Character string - \o Mapped to QString + \li VARCHAR + \li Character string + \li Mapped to QString \row - \o TINYTEXT - \o Character string - \o Mapped to QString + \li TINYTEXT + \li Character string + \li Mapped to QString \row - \o TEXT - \o Character string - \o Mapped to QString + \li TEXT + \li Character string + \li Mapped to QString \row - \o MEDIUMTEXT - \o Character string - \o Mapped to QString + \li MEDIUMTEXT + \li Character string + \li Mapped to QString \row - \o LONGTEXT - \o Character string - \o Mapped to QString + \li LONGTEXT + \li Character string + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o all BLOB types - \o BLOB - \o Mapped to QByteArray + \li all BLOB types + \li BLOB + \li Mapped to QByteArray \row - \o DATE - \o Date without Time - \o Mapped to QDate + \li DATE + \li Date without Time + \li Mapped to QDate \row - \o DATETIME - \o Date and Time - \o Mapped to QDateTime + \li DATETIME + \li Date and Time + \li Mapped to QDateTime \row - \o TIMESTAMP - \o Date and Time - \o Mapped to QDateTime + \li TIMESTAMP + \li Date and Time + \li Mapped to QDateTime \row - \o TIME - \o Time - \o Mapped to QTime + \li TIME + \li Time + \li Mapped to QTime \row - \o YEAR - \o Year (int) - \o Mapped to QDateTime + \li YEAR + \li Year (int) + \li Mapped to QDateTime \row - \o ENUM - \o Enumeration of Value Set - \o Mapped to QString + \li ENUM + \li Enumeration of Value Set + \li Mapped to QString \endtable \section2 Oracle Call Interface Data Types \table 90% \header - \o Oracle Call Interface data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li Oracle Call Interface data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o NUMBER - \o FLOAT, DOUBLE, PRECISIONc REAL - \o By default mapping to QString + \li NUMBER + \li FLOAT, DOUBLE, PRECISIONc REAL + \li By default mapping to QString \row - \o NUMBER(38) - \o INTEGER INT SMALLINT - \o typedef qint8/16/32/64 + \li NUMBER(38) + \li INTEGER INT SMALLINT + \li typedef qint8/16/32/64 \row - \o NUMBER(p,s) - \o NUMERIC(p,s) DECIMAL(p,s)a - \o By default mapping to QString + \li NUMBER(p,s) + \li NUMERIC(p,s) DECIMAL(p,s)a + \li By default mapping to QString \row - \o NVARCHAR2(n) - \o Character string (NATIONAL CHARACTER VARYING(n) NATIONAL + \li NVARCHAR2(n) + \li Character string (NATIONAL CHARACTER VARYING(n) NATIONAL CHAR VARYING(n) NCHAR VARYING(n)) - \o Mapped to QString + \li Mapped to QString \row - \o NCHAR(n) - \o Character string (NATIONAL CHARACTER(n) NATIONAL CHAR(n) + \li NCHAR(n) + \li Character string (NATIONAL CHARACTER(n) NATIONAL CHAR(n) NCHAR(n)) - \o Mapped to QString + \li Mapped to QString \row - \o CHAR(n) - \o Character string (CHARACTER(n) CHAR(n)) - \o Mapped to QString + \li CHAR(n) + \li Character string (CHARACTER(n) CHAR(n)) + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o BLOB - \o A binary large object - \o Mapped to QByteArray + \li BLOB + \li A binary large object + \li Mapped to QByteArray \row - \o TIMESTAMP - \o Year, month, and day values of date, as well as hour, minute, + \li TIMESTAMP + \li Year, month, and day values of date, as well as hour, minute, and second values of time - \o Mapped to QDateTime + \li Mapped to QDateTime \endtable \section2 ODBC Data Types \table 90% \header - \o ODBC data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li ODBC data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o BIT - \o Boolean - \o BOOL + \li BIT + \li Boolean + \li BOOL \row - \o TINYINT - \o 8 bit integer - \o typedef qint8 + \li TINYINT + \li 8 bit integer + \li typedef qint8 \row - \o SMALLINT - \o 16-bit signed integer - \o typedef qint16 + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 \row - \o INTEGER - \o 32-bit signed integer - \o typedef qint32 + \li INTEGER + \li 32-bit signed integer + \li typedef qint32 \row - \o BIGINT - \o 64-bit signed integer - \o typedef qint64 + \li BIGINT + \li 64-bit signed integer + \li typedef qint64 \row - \o REAL - \o 32-bit Single-precision floating point - \o By default mapping to QString + \li REAL + \li 32-bit Single-precision floating point + \li By default mapping to QString \row - \o FLOAT - \o 64-bit Double floating point - \o By default mapping to QString + \li FLOAT + \li 64-bit Double floating point + \li By default mapping to QString \row - \o DOUBLE - \o 64-bit Double floating point - \o By default mapping to QString + \li DOUBLE + \li 64-bit Double floating point + \li By default mapping to QString \row - \o CHAR - \o Character string - \o Mapped to QString + \li CHAR + \li Character string + \li Mapped to QString \row - \o VARCHAR - \o Character string - \o Mapped to QString + \li VARCHAR + \li Character string + \li Mapped to QString \row - \o LONGVARCHAR - \o Character string - \o Mapped to QString + \li LONGVARCHAR + \li Character string + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o DATE - \o Character string - \o Mapped to QDate + \li DATE + \li Character string + \li Mapped to QDate \row - \o TIME - \o Character Time, Character string - \o Mapped to QTime + \li TIME + \li Character Time, Character string + \li Mapped to QTime \row - \o TIMESTAMP - \o Character Time, Character string - \o Mapped to QDateTime + \li TIMESTAMP + \li Character Time, Character string + \li Mapped to QDateTime \endtable \section2 PostgreSQL Data Types \table 90% \header - \o PostgreSQL data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li PostgreSQL data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o BOOLEAN - \o Boolean - \o bool + \li BOOLEAN + \li Boolean + \li bool \row - \o SMALLINT - \o 16-bit signed integer - \o typedef qint16 + \li SMALLINT + \li 16-bit signed integer + \li typedef qint16 \row - \o INTEGER - \o 32-bit signed integer - \o typedef qint32 + \li INTEGER + \li 32-bit signed integer + \li typedef qint32 \row - \o BIGINT - \o 64-bit signed integer - \o typedef qint64 + \li BIGINT + \li 64-bit signed integer + \li typedef qint64 \row - \o REAL - \o 32-bit variable-precision floating point - \o By default mapping to QString + \li REAL + \li 32-bit variable-precision floating point + \li By default mapping to QString \row - \o DOUBLE PRECISION - \o 64-bit variable-precision floating point - \o By default mapping to QString + \li DOUBLE PRECISION + \li 64-bit variable-precision floating point + \li By default mapping to QString \row - \o DECIMAL VARIABLE - \o user-specified precision, exact - \o Mapped to QString + \li DECIMAL VARIABLE + \li user-specified precision, exact + \li Mapped to QString \row - \o NUMERIC VARIABLE - \o user-specified precision, exact - \o Mapped to QString + \li NUMERIC VARIABLE + \li user-specified precision, exact + \li Mapped to QString \row - \o VARCHAR - \o variable-length character string - \o Mapped to QString + \li VARCHAR + \li variable-length character string + \li Mapped to QString \row - \o CHARACTER - \o Character string of fixed-length - \o Mapped to QString + \li CHARACTER + \li Character string of fixed-length + \li Mapped to QString \row - \o TEXT - \o Character string of variable-length - \o Mapped to QString + \li TEXT + \li Character string of variable-length + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o TIMESTAMP - \o 8 bytes, both date and time - \o Mapped to QDateTime + \li TIMESTAMP + \li 8 bytes, both date and time + \li Mapped to QDateTime \row - \o TIMESTAMP - \o 8 bytes, both date and time, with time zone - \o Mapped to QDateTime + \li TIMESTAMP + \li 8 bytes, both date and time, with time zone + \li Mapped to QDateTime \row - \o DATE - \o 4 bytes, dates only - \o Mapped to QDate + \li DATE + \li 4 bytes, dates only + \li Mapped to QDate \row - \o TIME - \o 8 bytes, times of day only 00:00:00.00 - 23:59:59.99 - \o Mapped to QTime + \li TIME + \li 8 bytes, times of day only 00:00:00.00 - 23:59:59.99 + \li Mapped to QTime \row - \o TIME - \o 12 bytes times of day only, with time zone 00:00:00.00+12 - \o Mapped to QDateTime + \li TIME + \li 12 bytes times of day only, with time zone 00:00:00.00+12 + \li Mapped to QDateTime \endtable \section2 QSQLITE SQLite version 3 Data Types \table 90% \header - \o QSQLITE SQLite version 3 data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li QSQLITE SQLite version 3 data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o NULL - \o NULL value. - \o NULL + \li NULL + \li NULL value. + \li NULL \row - \o INTEGER - \o Signed integer, stored in 8, 16, 24, 32, 48, or 64-bits + \li INTEGER + \li Signed integer, stored in 8, 16, 24, 32, 48, or 64-bits depending on the magnitude of the value. - \o typedef qint8/16/32/64 + \li typedef qint8/16/32/64 \row - \o REAL - \o 64-bit floating point value. - \o By default mapping to QString + \li REAL + \li 64-bit floating point value. + \li By default mapping to QString \row - \o TEXT - \o Character string (UTF-8, UTF-16BE or UTF-16-LE). - \o Mapped to QString + \li TEXT + \li Character string (UTF-8, UTF-16BE or UTF-16-LE). + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o BLOB - \o The value is a BLOB of data, stored exactly as it was input. - \o Mapped to QByteArray + \li BLOB + \li The value is a BLOB of data, stored exactly as it was input. + \li Mapped to QByteArray \endtable \section2 Sybase Adaptive Server Data Types \table 90% \header - \o Sybase Adaptive Server data type - \o SQL type description - \o Recommended input (C++ or Qt data type) + \li Sybase Adaptive Server data type + \li SQL type description + \li Recommended input (C++ or Qt data type) \row - \o BINARY - \o Describes a fixed-length binary value up to 255 bytes in size. - \o Mapped to QByteArray + \li BINARY + \li Describes a fixed-length binary value up to 255 bytes in size. + \li Mapped to QByteArray \row - \o CHAR - \o Character String - \o Mapped to QString + \li CHAR + \li Character String + \li Mapped to QString \row - \o DATETIME - \o Date and time. Range: 1753-01-01 00:00:00 through 9999-12-31 23:59:59. - \o Mapped to QDateTime + \li DATETIME + \li Date and time. Range: 1753-01-01 00:00:00 through 9999-12-31 23:59:59. + \li Mapped to QDateTime \row - \o NCHAR - \o Character String of fixed length - \o Mapped to QString + \li NCHAR + \li Character String of fixed length + \li Mapped to QString \row - \o NVARACHAR - \o Character String of variable length - \o Mapped to QString + \li NVARACHAR + \li Character String of variable length + \li Mapped to QString \row - \o VARCHAR - \o Character String of fixed length - \o Mapped to QString + \li VARCHAR + \li Character String of fixed length + \li Mapped to QString \row - \o CLOB - \o Character large string object - \o Mapped to QString + \li CLOB + \li Character large string object + \li Mapped to QString \row - \o TIMESTAMP - \o A unique number within a database - \o Mapped to QString + \li TIMESTAMP + \li A unique number within a database + \li Mapped to QString \row - \o SMALLDATETIME - \o Date and time. Range: 1900-01-01 00:00 through 2079-12-31 23:59 - \o Mapped to QDateTime + \li SMALLDATETIME + \li Date and time. Range: 1900-01-01 00:00 through 2079-12-31 23:59 + \li Mapped to QDateTime \row - \o UNICHAR - \o Character String of fixed length.(Unicode) - \o Mapped to QString + \li UNICHAR + \li Character String of fixed length.(Unicode) + \li Mapped to QString \row - \o UNIVARCHAR - \o Character String of variable length.(Unicode) - \o Mapped to QString + \li UNIVARCHAR + \li Character String of variable length.(Unicode) + \li Mapped to QString \row - \o VARBINARY - \o Describes a variable-length binary value up to 255 bytes in size - \o Mapped to QByteArray + \li VARBINARY + \li Describes a variable-length binary value up to 255 bytes in size + \li Mapped to QByteArray \endtable \section2 SQLite Version 2 diff --git a/doc/src/sql/sql-programming/sql-driver.qdoc b/doc/src/sql/sql-programming/sql-driver.qdoc index 667b9eba54..eec61abd15 100644 --- a/doc/src/sql/sql-programming/sql-driver.qdoc +++ b/doc/src/sql/sql-programming/sql-driver.qdoc @@ -49,18 +49,18 @@ are provided with Open Source Versions of Qt. \table - \header \o Driver name \o DBMS - \row \o \link #QDB2 QDB2\endlink \o IBM DB2 (version 7.1 and above) - \row \o \link #QIBASE QIBASE\endlink \o Borland InterBase - \row \o \link #QMYSQL QMYSQL\endlink \o MySQL - \row \o \link #QOCI QOCI\endlink \o Oracle Call Interface Driver - \row \o \link #QODBC QODBC\endlink - \o Open Database Connectivity (ODBC) - Microsoft SQL Server and other + \header \li Driver name \li DBMS + \row \li \link #QDB2 QDB2\endlink \li IBM DB2 (version 7.1 and above) + \row \li \link #QIBASE QIBASE\endlink \li Borland InterBase + \row \li \link #QMYSQL QMYSQL\endlink \li MySQL + \row \li \link #QOCI QOCI\endlink \li Oracle Call Interface Driver + \row \li \link #QODBC QODBC\endlink + \li Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases - \row \o \link #QPSQL QPSQL\endlink \o PostgreSQL (versions 7.3 and above) - \row \o \link #QSQLITE2 QSQLITE2\endlink \o SQLite version 2 - \row \o \link #QSQLITE QSQLITE\endlink \o SQLite version 3 - \row \o \link #QTDS QTDS\endlink \o Sybase Adaptive Server \note obsolete from Qt 4.7 + \row \li \link #QPSQL QPSQL\endlink \li PostgreSQL (versions 7.3 and above) + \row \li \link #QSQLITE2 QSQLITE2\endlink \li SQLite version 2 + \row \li \link #QSQLITE QSQLITE\endlink \li SQLite version 3 + \row \li \link #QTDS QTDS\endlink \li Sybase Adaptive Server \note obsolete from Qt 4.7 \endtable SQLite is the in-process database system with the best test coverage @@ -69,7 +69,7 @@ Linux. The completeness of the support for other systems depends on the availability and quality of client libraries. - \bold{Note:} To build a driver plugin you need to have the appropriate + \b{Note:} To build a driver plugin you need to have the appropriate client library for your Database Management System (DBMS). This provides access to the API exposed by the DBMS, and is typically shipped with it. Most installation programs also allow you to install "development @@ -123,7 +123,7 @@ \snippet doc/src/snippets/code/doc_src_sql-driver.cpp 2 - \bold{Note:} \c{@outval1} and \c{@outval2} are variables local to the current + \b{Note:} \c{@outval1} and \c{@outval2} are variables local to the current connection and will not be affected by queries sent from another host or connection. @@ -185,59 +185,59 @@ \list - \o Download the following components: + \li Download the following components: \list - \o \c{MinGW-5.1.6.exe} - \o \c{mingw-utils-0.3.tar.gz} - \o Qt sources, e.g. \c{qt-everywhere-opensource-src-4.6.2.zip} - \o \c{mysql-5.1.35-win32.msi} + \li \c{MinGW-5.1.6.exe} + \li \c{mingw-utils-0.3.tar.gz} + \li Qt sources, e.g. \c{qt-everywhere-opensource-src-4.6.2.zip} + \li \c{mysql-5.1.35-win32.msi} \endlist - \o Install \c{MinGW-5.1.6.exe} in, e.g. \c{C:\MinGW}. + \li Install \c{MinGW-5.1.6.exe} in, e.g. \c{C:\MinGW}. - \o Extract \c{mingw-utils-0.3.tar.gz} into, e.g. \c{C:\MinGW}. + \li Extract \c{mingw-utils-0.3.tar.gz} into, e.g. \c{C:\MinGW}. - \o Add the path for \c{MinGW-5.1.6.exe} to your \c{PATH} variable, + \li Add the path for \c{MinGW-5.1.6.exe} to your \c{PATH} variable, e.g. \c{C:\MinGW\bin;} - \o Extract the Qt sources, (\c{qt-everywhere-opensource-src-4.6.2.zip}), + \li Extract the Qt sources, (\c{qt-everywhere-opensource-src-4.6.2.zip}), into, e.g. \c{C:\Qt}. - \o Add the path for the eventual Qt binary to your \c{PATH} variable, + \li Add the path for the eventual Qt binary to your \c{PATH} variable, e.g. \c{C:\Qt\4.6.2\bin;}. - \o Install MySQL (\c{mysql-5.1.35-win32.msi}), customizing the + \li Install MySQL (\c{mysql-5.1.35-win32.msi}), customizing the components. Select only the headers and libraries. Install in, e.g. \c{C:\MySQL\MySQL51}. - \o Open the DOS prompt, go to \c{C:\MySQL\MySQL51\lib\opt}, and run + \li Open the DOS prompt, go to \c{C:\MySQL\MySQL51\lib\opt}, and run the following commands: \list - \o \c{reimp -d libmysql.lib} - \o \c{dlltool -k -d libmysql.def -l libmysql.a} + \li \c{reimp -d libmysql.lib} + \li \c{dlltool -k -d libmysql.def -l libmysql.a} \endlist - \o Open the DOS prompt, go to \c{C:\Qt\4.6.2} and run the following commands: + \li Open the DOS prompt, go to \c{C:\Qt\4.6.2} and run the following commands: \list - \o \c{configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql + \li \c{configure.exe -debug-and-release -platform win32-g++ -qt-sql-mysql -l mysql -I C:\MySQL\MySQL51\include -L C:\MySQL\MySQL51\lib\opt} - \o \c{mingw32-make sub-src} + \li \c{mingw32-make sub-src} \endlist This step takes a long time. - \o Open the DOS prompt, go to + \li Open the DOS prompt, go to \c{C:\Qt\4.6.2\src\plugins\sqldrivers\mysql} and run the following command: \list - \o \c{qmake "INCLUDEPATH+=C:\MySQL\MySQL51\include" "LIBS+=-L. mysql" mysql.pro} + \li \c{qmake "INCLUDEPATH+=C:\MySQL\MySQL51\include" "LIBS+=-L. mysql" mysql.pro} \endlist - \o Now the following libraries are ready in \c{C:\Qt\4.6.2\plugins\sqldrivers}. + \li Now the following libraries are ready in \c{C:\Qt\4.6.2\plugins\sqldrivers}. \list - \o \c{libqsqlmysql4.a} - \o \c{libqsqlmysqld4.a} - \o \c{qsqlmysql4.dll} - \o \c{qsqlmysqld4.dll} + \li \c{libqsqlmysql4.a} + \li \c{libqsqlmysqld4.a} + \li \c{qsqlmysql4.dll} + \li \c{qsqlmysqld4.dll} \endlist To use the SDK and QtCreator directly, copy these libraries to your \c{C:\Qt\...\qt\plugins\sqldrivers\}, and copy @@ -287,8 +287,8 @@ Oracle library files required to build the driver: \list - \i \c libclntsh.so (all versions) - \i \c libwtc9.so (only Oracle 9) + \li \c libclntsh.so (all versions) + \li \c libwtc9.so (only Oracle 9) \endlist Tell \c qmake where to find the Oracle header files and shared @@ -301,7 +301,7 @@ Instant Client Package SDK (you need to adjust the version number accordingly): \snippet doc/src/snippets/code/doc_src_sql-driver.qdoc 7 - \bold{Note:} If you are using the Oracle Instant Client package, + \b{Note:} If you are using the Oracle Instant Client package, you will need to set LD_LIBRARY_PATH when building the OCI SQL plugin and when running an application that uses the OCI SQL plugin. You can avoid this requirement by setting and RPATH and listing all of the @@ -331,7 +331,7 @@ \snippet doc/src/snippets/code/doc_src_sql-driver.qdoc 9 - \bold{Note:} This database plugin is not supported for Windows CE. + \b{Note:} This database plugin is not supported for Windows CE. \target QODBC \section2 QODBC for Open Database Connectivity (ODBC) @@ -345,7 +345,7 @@ driver manager that is installed on your system. The QODBC plugin then allows you to use these data sources in your Qt applications. - \bold{Note:} You should use native drivers in preference to the ODBC + \b{Note:} You should use native drivers in preference to the ODBC driver where they are available. ODBC support can be used as a fallback for compliant databases if no native drivers are available. @@ -396,7 +396,7 @@ \snippet doc/src/snippets/code/doc_src_sql-driver.cpp 10 - \bold{Note:} The value returned by the stored procedure's return statement + \b{Note:} The value returned by the stored procedure's return statement is discarded. \section3 ODBC Unicode Support @@ -435,7 +435,7 @@ If you are not using a Microsoft compiler, replace \c nmake with \c make in the line above. - \bold{Note:} This database plugin is not officially supported for Windows CE. + \b{Note:} This database plugin is not officially supported for Windows CE. \target QPSQL \section2 QPSQL for PostgreSQL (Version 7.3 and Above) @@ -496,7 +496,7 @@ Users of MinGW may wish to consult the following online document: \l{PostgreSQL MinGW/Native Windows}. - \bold{Note:} This database plugin is not supported for Windows CE. + \b{Note:} This database plugin is not supported for Windows CE. \target QTDS \section2 QTDS for Sybase Adaptive Server @@ -515,11 +515,11 @@ Under Unix, two libraries are available which support the TDS protocol: \list - \i FreeTDS, a free implementation of the TDS protocol + \li FreeTDS, a free implementation of the TDS protocol (\l{http://www.freetds.org}). Note that FreeTDS is not yet stable, so some functionality may not work as expected. - \i Sybase Open Client, available from \l{http://www.sybase.com}. + \li Sybase Open Client, available from \l{http://www.sybase.com}. Note for Linux users: Get the Open Client RPM from \l{http://linux.sybase.com}. \endlist @@ -545,7 +545,7 @@ are not using a Microsoft compiler, replace \c nmake with \c make in the line above. - \bold{Note:} This database plugin is not supported for Windows CE. + \b{Note:} This database plugin is not supported for Windows CE. \target QDB2 \section2 QDB2 for IBM DB2 (Version 7.1 and Above) @@ -582,7 +582,7 @@ If you are not using a Microsoft compiler, replace \c nmake with \c make in the line above. - \bold{Note:} This database plugin is not supported for Windows CE. + \b{Note:} This database plugin is not supported for Windows CE. \target QSQLITE2 \section2 QSQLITE2 for SQLite Version 2 @@ -745,7 +745,7 @@ Note that \c{C:\interbase\bin} must be in the \c PATH. - \bold{Note:} This database plugin is not supported for Windows CE. + \b{Note:} This database plugin is not supported for Windows CE. \target troubleshooting \section1 Troubleshooting @@ -763,16 +763,16 @@ make sure that the following requirements are met: \list - \i Ensure that you are using a shared Qt library; you cannot use the + \li Ensure that you are using a shared Qt library; you cannot use the plugins with a static build. - \i Ensure that the plugin is in the correct directory. You can use + \li Ensure that the plugin is in the correct directory. You can use QApplication::libraryPaths() to determine where Qt looks for plugins. - \i Ensure that the client libraries of the DBMS are available on the + \li Ensure that the client libraries of the DBMS are available on the system. On Unix, run the command \c{ldd} and pass the name of the plugin as parameter, for example \c{ldd libqsqlmysql.so}. You will get a warning if any of the client libraries couldn't be found. On Windows, you can use Visual Studio's dependency walker. - \i Compile Qt with \c{QT_DEBUG_COMPONENT} defined to get very verbose + \li Compile Qt with \c{QT_DEBUG_COMPONENT} defined to get very verbose debug output when loading plugins. \endlist diff --git a/doc/src/sql/sql-programming/sql-programming.qdoc b/doc/src/sql/sql-programming/sql-programming.qdoc index 787b48718d..6ebb40b755 100644 --- a/doc/src/sql/sql-programming/sql-programming.qdoc +++ b/doc/src/sql/sql-programming/sql-programming.qdoc @@ -52,18 +52,18 @@ \section1 Topics: \list - \o \l{Database Classes} - \o \l{Connecting to Databases} + \li \l{Database Classes} + \li \l{Connecting to Databases} \list - \o \l{SQL Database Drivers} + \li \l{SQL Database Drivers} \endlist - \o \l{Executing SQL Statements} + \li \l{Executing SQL Statements} \list - \o \l{Data Types for Qt-supported Database Systems} + \li \l{Data Types for Qt-supported Database Systems} \endlist - \o \l{Using the SQL Model Classes} - \o \l{Presenting Data in a Table View} - \o \l{Creating Data-Aware Forms} + \li \l{Using the SQL Model Classes} + \li \l{Presenting Data in a Table View} + \li \l{Creating Data-Aware Forms} \endlist \section1 Database Classes @@ -338,12 +338,12 @@ QSqlTableModel, and QSqlRelationalTableModel. \table - \row \o QSqlQueryModel - \o A read-only model based on an arbitrary SQL query. - \row \o QSqlTableModel - \o A read-write model that works on a single table. - \row \o QSqlRelationalTableModel - \o A QSqlTableModel subclass with foreign key support. + \row \li QSqlQueryModel + \li A read-only model based on an arbitrary SQL query. + \row \li QSqlTableModel + \li A read-write model that works on a single table. + \row \li QSqlRelationalTableModel + \li A QSqlTableModel subclass with foreign key support. \endtable These classes derive from QAbstractTableModel (which in turn @@ -435,8 +435,8 @@ pitfalls, though: \list - \o Without any caching, performance may drop significantly. - \o If you modify a primary key, the record might slip through + \li Without any caching, performance may drop significantly. + \li If you modify a primary key, the record might slip through your fingers while you are trying to populate it. \endlist @@ -450,8 +450,8 @@ that \c authorid is a foreign key. \table - \row \o \inlineimage noforeignkeys.png - \o \inlineimage foreignkeys.png + \row \li \inlineimage noforeignkeys.png + \li \inlineimage foreignkeys.png \endtable The screenshot on the left shows a plain QSqlTableModel in a |