diff options
Diffstat (limited to 'doc/codesnippets/doc/src/snippets/code/doc_src_sql-driver.qdoc')
| -rw-r--r-- | doc/codesnippets/doc/src/snippets/code/doc_src_sql-driver.qdoc | 239 |
1 files changed, 0 insertions, 239 deletions
diff --git a/doc/codesnippets/doc/src/snippets/code/doc_src_sql-driver.qdoc b/doc/codesnippets/doc/src/snippets/code/doc_src_sql-driver.qdoc deleted file mode 100644 index 74cd8dc45..000000000 --- a/doc/codesnippets/doc/src/snippets/code/doc_src_sql-driver.qdoc +++ /dev/null @@ -1,239 +0,0 @@ -//! [0] --no-sql-<driver> ... Disable SQL <driver> entirely. --qt-sql-<driver> ... Enable a SQL <driver> in the Qt Library, by default - none are turned on. --plugin-sql-<driver> Enable SQL <driver> as a plugin to be linked to - at run time. - - Possible values for <driver>: - [ db2 ibase mysql oci odbc psql sqlite sqlite2 tds ] -//! [0] - - -//! [1] -create procedure qtestproc (OUT param1 INT, OUT param2 INT) -BEGIN - set param1 = 42; - set param2 = 43; -END -//! [1] - - -//! [2] -QSqlQuery q; -q.exec("call qtestproc (@outval1, @outval2)"); -q.exec("select @outval1, @outval2"); -q.next(); -qDebug() << q.value(0) << q.value(1); // outputs "42" and "43" -//! [2] - - -//! [3] -cd $QTDIR/src/plugins/sqldrivers/mysql -qmake "INCLUDEPATH+=/usr/local/include" "LIBS+=-L/usr/local/lib -lmysqlclient_r" mysql.pro -make -//! [3] - - -//! [4] -cd $QTDIR/src/plugins/sqldrivers/mysql -make install -//! [4] - - -//! [5] -cd %QTDIR%\src\plugins\sqldrivers\mysql -qmake "INCLUDEPATH+=C:\MySQL\include" "LIBS+=C:\MYSQL\MySQL Server <version>\lib\opt\libmysql.lib" mysql.pro -nmake -//! [5] - - -//! [6] -cd $QTDIR/src/plugins/sqldrivers/oci -qmake "INCLUDEPATH+=$ORACLE_HOME/rdbms/public $ORACLE_HOME/rdbms/demo" "LIBS+=-L$ORACLE_HOME/lib -lclntsh -lwtc9" oci.pro -make -//! [6] - - -//! [7] -cd $QTDIR/src/plugins/sqldrivers/oci -qmake "INCLUDEPATH+=/usr/include/oracle/10.1.0.3/client/" "LIBS+=-L/usr/lib/oracle/10.1.0.3/client/lib" oci.pro -make -//! [7] - - -//! [8] -set INCLUDE=%INCLUDE%;c:\oracle\oci\include -set LIB=%LIB%;c:\oracle\oci\lib\msvc -cd %QTDIR%\src\plugins\sqldrivers\oci -qmake oci.pro -nmake -//! [8] - - -//! [9] -set PATH=%PATH%;c:\oracle\bin -//! [9] - - -//! [10] -\\ STORED_PROC uses the return statement or returns multiple result sets -QSqlQuery query; -query.setForwardOnly(true); -query.exec("{call STORED_PROC}"); -//! [10] - - -//! [11] -cd $QTDIR/src/plugins/sqldrivers/odbc -qmake "INCLUDEPATH+=/usr/local/unixODBC/include" "LIBS+=-L/usr/local/unixODBC/lib -lodbc" -make -//! [11] - - -//! [12] -cd %QTDIR%\src\plugins\sqldrivers\odbc -qmake odbc.pro -nmake -//! [12] - - -//! [13] -cd $QTDIR/src/plugins/sqldrivers/psql -qmake "INCLUDEPATH+=/usr/include/pgsql" "LIBS+=-L/usr/lib -lpq" psql.pro -make -//! [13] - - -//! [14] -cd $QTDIR/src/plugins/sqldrivers/psql -make install -//! [14] - - -//! [15] -cd %QTDIR%\src\plugins\sqldrivers\psql -qmake "INCLUDEPATH+=C:\psql\include" "LIBS+=C:\psql\lib\ms\libpq.lib" psql.pro -nmake -//! [15] - - -//! [16] -cd $QTDIR/src/plugins/sqldrivers/tds -qmake "INCLUDEPATH=$SYBASE/include" "LIBS=-L$SYBASE/lib -lsybdb" -make -//! [16] - - -//! [17] -cd %QTDIR%\src\plugins\sqldrivers\tds -qmake "LIBS+=NTWDBLIB.LIB" tds.pro -nmake -//! [17] - - -//! [18] -cd $QTDIR/src/plugins/sqldrivers/db2 -qmake "INCLUDEPATH+=$DB2DIR/include" "LIBS+=-L$DB2DIR/lib -ldb2" -make -//! [18] - - -//! [19] -cd $QTDIR/src/plugins/sqldrivers/db2 -make install -//! [19] - - -//! [20] -cd %QTDIR%\src\plugins\sqldrivers\db2 -qmake "INCLUDEPATH+=<DB2 home>/sqllib/include" "LIBS+=<DB2 home>/sqllib/lib/db2cli.lib" -nmake -//! [20] - - -//! [21] -cd $QTDIR/src/plugins/sqldrivers/sqlite -qmake "INCLUDEPATH+=$SQLITE/include" "LIBS+=-L$SQLITE/lib -lsqlite" -make -//! [21] - - -//! [22] -cd $QTDIR/src/plugins/sqldrivers/sqlite -make install -//! [22] - - -//! [23] -cd %QTDIR%\src\plugins\sqldrivers\sqlite -qmake "INCLUDEPATH+=C:\SQLITE\INCLUDE" "LIBS+=C:\SQLITE\LIB\SQLITE3.LIB" sqlite.pro -nmake -//! [23] - - -//! [24] -db.setHostName("MyServer"); -db.setDatabaseName("C:\\test.gdb"); -//! [24] - - -//! [25] -// connect to database using the Latin-1 character set -db.setConnectOptions("ISC_DPB_LC_CTYPE=Latin1"); -db.open(); -//! [25] - - -//! [26] -QSqlQuery q; -q.exec("execute procedure my_procedure"); -q.next(); -qDebug() << q.value(0); // outputs the first RETURN/OUT value -//! [26] - - -//! [27] -cd $QTDIR/src/plugins/sqldrivers/ibase -qmake "INCLUDEPATH+=/opt/interbase/include" "LIBS+=-L/opt/interbase/lib" ibase.pro -make -//! [27] - - -//! [28] -cd $QTDIR/src/plugins/sqldrivers/ibase -qmake "INCLUDEPATH+=/opt/interbase/include" "LIBS+=-L/opt/interbase/lib -lfbclient" ibase.pro -make -//! [28] - - -//! [29] -cd %QTDIR%\src\plugins\sqldrivers\ibase -qmake "INCLUDEPATH+=C:\interbase\include" ibase.pro -nmake -//! [29] - - -//! [30] -cd %QTDIR%\src\plugins\sqldrivers\ibase -qmake "INCLUDEPATH+=C:\interbase\include" "LIBS+=-lfbclient" ibase.pro -nmake -//! [30] - - -//! [31] -QSqlDatabase: QMYSQL driver not loaded -QSqlDatabase: available drivers: QMYSQL -//! [31] - -//! [32] -configure -I /usr/include/oracle/10.1.0.3/client -L /usr/lib/oracle/10.1.0.3/client/lib -R /usr/lib/oracle/10.1.0.3/client/lib -lclntsh -lnnz10 -make -//! [32] - -//! [33] -cd $QTDIR/src/plugins/sqldrivers/oci -qmake "INCLUDEPATH+=/usr/include/oracle/10.1.0.3/client" "LIBS+=-L/usr/lib/oracle/10.1.0.3/client/lib -Wl,-rpath,/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -lnnz10" oci.pro -make -//! [33] - |