Test conversion to TQt3 from Qt3 8c6fc1f8e35fd264dd01c582ca5e7549b32ab731

79 files changed, 1968 insertions, 0 deletions

diff --git a/examples/sql/overview/basicbrowsing/README b/examples/sql/overview/basicbrowsing/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/basicbrowsing/basicbrowsing.pro b/examples/sql/overview/basicbrowsing/basicbrowsing.pro
new file mode 100644
index 000000000..b7245c992
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing/basicbrowsing.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
+
diff --git a/examples/sql/overview/basicbrowsing/main.cpp b/examples/sql/overview/basicbrowsing/main.cpp
new file mode 100644
index 000000000..a63182444
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing/main.cpp
@@ -0,0 +1,35 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlquery.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlDatabase *oracledb = TQSqlDatabase::database( "ORACLE" );
+	// Copy data from the oracle database to the ODBC (default)
+	// database
+	TQSqlQuery target;
+	TQSqlQuery query( "SELECT id, name FROM people", oracledb );
+	if ( query.isActive() ) {
+	    while ( query.next() ) {
+		target.exec( "INSERT INTO people ( id, name ) VALUES ( " + 
+			      query.value(0).toString() + 
+			      ", '" + query.value(1).toString() +  "' )" );
+	    }
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/basicbrowsing2/README b/examples/sql/overview/basicbrowsing2/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing2/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/basicbrowsing2/basicbrowsing2.pro b/examples/sql/overview/basicbrowsing2/basicbrowsing2.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing2/basicbrowsing2.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/basicbrowsing2/main.cpp b/examples/sql/overview/basicbrowsing2/main.cpp
new file mode 100644
index 000000000..5f7cbcb9f
--- /dev/null
+++ b/examples/sql/overview/basicbrowsing2/main.cpp
@@ -0,0 +1,43 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlquery.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlDatabase *oracledb = TQSqlDatabase::database( "ORACLE" );
+	// Copy data from the oracle database to the ODBC (default)
+	// database
+	TQSqlQuery target;
+	TQSqlQuery query( "SELECT id, name FROM people", oracledb );
+	int count = 0;
+        if ( query.isActive() ) {
+            while ( query.next() ) {
+                target.exec( "INSERT INTO people ( id, name ) VALUES ( " + 
+                              query.value(0).toString() + 
+                              ", '" + query.value(1).toString() +  "' )" );
+                if ( target.isActive() ) 
+                    count += target.numRowsAffected();
+            }
+        }
+    }
+
+    return 0;
+}
+
+
+
+
+
diff --git a/examples/sql/overview/basicdatamanip/README b/examples/sql/overview/basicdatamanip/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/basicdatamanip/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/basicdatamanip/basicdatamanip.pro b/examples/sql/overview/basicdatamanip/basicdatamanip.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/basicdatamanip/basicdatamanip.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/basicdatamanip/main.cpp b/examples/sql/overview/basicdatamanip/main.cpp
new file mode 100644
index 000000000..7777f9813
--- /dev/null
+++ b/examples/sql/overview/basicdatamanip/main.cpp
@@ -0,0 +1,40 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlquery.h>
+#include "../connection.h"
+
+bool createConnections();
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    int rows = 0;
+
+    if ( createConnections() ) {
+	TQSqlQuery query( "INSERT INTO staff ( id, forename, surname, salary ) "
+		     "VALUES ( 1155, 'Ginger', 'Davis', 50000 )" );
+	if ( query.isActive() ) rows += query.numRowsAffected() ;
+
+	query.exec( "UPDATE staff SET salary=60000 WHERE id=1155" );
+	if ( query.isActive() ) rows += query.numRowsAffected() ;
+
+	query.exec( "DELETE FROM staff WHERE id=1155" ); 
+	if ( query.isActive() ) rows += query.numRowsAffected() ;
+    }
+
+    return ( rows == 3 ) ? 0 : 1; 
+}
+
+
+
diff --git a/examples/sql/overview/connect1/README b/examples/sql/overview/connect1/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/connect1/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/connect1/connect1.pro b/examples/sql/overview/connect1/connect1.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/connect1/connect1.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/connect1/main.cpp b/examples/sql/overview/connect1/main.cpp
new file mode 100644
index 000000000..16f3eeab2
--- /dev/null
+++ b/examples/sql/overview/connect1/main.cpp
@@ -0,0 +1,31 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include "../connection.h"
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    TQSqlDatabase *defaultDB = TQSqlDatabase::addDatabase( DB_SALES_DRIVER );
+    defaultDB->setDatabaseName( DB_SALES_DBNAME );
+    defaultDB->setUserName( DB_SALES_USER );
+    defaultDB->setPassword( DB_SALES_PASSWD );
+    defaultDB->setHostName( DB_SALES_HOST );
+
+    if ( defaultDB->open() ) {
+	// Database successfully opened; we can now issue SQL commands.
+    }
+
+    return 0;
+}
+
diff --git a/examples/sql/overview/connection.cpp b/examples/sql/overview/connection.cpp
new file mode 100644
index 000000000..0bbc7116c
--- /dev/null
+++ b/examples/sql/overview/connection.cpp
@@ -0,0 +1,50 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+#include <qsqldatabase.h>
+#include "connection.h"
+
+bool createConnections()
+{
+
+    TQSqlDatabase *defaultDB = TQSqlDatabase::addDatabase( DB_SALES_DRIVER );
+    defaultDB->setDatabaseName( DB_SALES_DBNAME );
+    defaultDB->setUserName( DB_SALES_USER );
+    defaultDB->setPassword( DB_SALES_PASSWD );
+    defaultDB->setHostName( DB_SALES_HOST );
+    if ( ! defaultDB->open() ) {
+	qWarning( "Failed to open sales database: " + defaultDB->lastError().text() );
+	return FALSE;
+    }
+
+    TQSqlDatabase *oracle = TQSqlDatabase::addDatabase( DB_ORDERS_DRIVER, "ORACLE" );
+    oracle->setDatabaseName( DB_ORDERS_DBNAME );
+    oracle->setUserName( DB_ORDERS_USER );
+    oracle->setPassword( DB_ORDERS_PASSWD );
+    oracle->setHostName( DB_ORDERS_HOST );
+    if ( ! oracle->open() ) {
+	qWarning( "Failed to open orders database: " + oracle->lastError().text() );
+	return FALSE;
+    }
+
+    TQSqlQuery q(TQString::null, defaultDB);
+    q.exec("create table people (id integer primary key, name char(40))");
+    q.exec("create table staff (id integer primary key, forename char(40), "
+           "surname char(40), salary float, statusid integer)");
+    q.exec("create table status (id integer primary key, name char(30))");
+    q.exec("create table creditors (id integer primary key, forename char(40), "
+           "surname char(40), city char(30))");
+    q.exec("create table prices (id integer primary key, name char(40), price float)");
+    q.exec("create table invoiceitem (id integer primary key, "
+           "pricesid integer, quantity integer, paiddate date)");
+
+    TQSqlQuery q2(TQString::null, oracle);
+    q2.exec("create table people (id integer primary key, name char(40))");
+
+    return TRUE;
+}
diff --git a/examples/sql/overview/connection.h b/examples/sql/overview/connection.h
new file mode 100644
index 000000000..c2c5195b6
--- /dev/null
+++ b/examples/sql/overview/connection.h
@@ -0,0 +1,24 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+// Enter your connection info here
+
+#define DB_SALES_DRIVER	    "TQSQLITE"
+#define DB_SALES_DBNAME	    ":memory:"
+#define DB_SALES_USER	    ""
+#define DB_SALES_PASSWD	    ""
+#define DB_SALES_HOST	    ""
+
+#define DB_ORDERS_DRIVER    "TQSQLITE"
+#define DB_ORDERS_DBNAME    ":memory:"
+#define DB_ORDERS_USER	    ""
+#define DB_ORDERS_PASSWD    ""
+#define DB_ORDERS_HOST	    ""
+
+bool createConnections();
diff --git a/examples/sql/overview/create_connections/README b/examples/sql/overview/create_connections/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/create_connections/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/create_connections/create_connections.pro b/examples/sql/overview/create_connections/create_connections.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/create_connections/create_connections.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/create_connections/main.cpp b/examples/sql/overview/create_connections/main.cpp
new file mode 100644
index 000000000..c4b3a9b71
--- /dev/null
+++ b/examples/sql/overview/create_connections/main.cpp
@@ -0,0 +1,26 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	// Databases successfully opened; get pointers to them:
+	TQSqlDatabase *oracledb = TQSqlDatabase::database( "ORACLE" );
+	// Now we can now issue SQL commands to the oracle connection
+	// or to the default connection
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/custom1/custom1.pro b/examples/sql/overview/custom1/custom1.pro
new file mode 100644
index 000000000..c490bedd0
--- /dev/null
+++ b/examples/sql/overview/custom1/custom1.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 = main.h
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/custom1/main.cpp b/examples/sql/overview/custom1/main.cpp
new file mode 100644
index 000000000..808444c7c
--- /dev/null
+++ b/examples/sql/overview/custom1/main.cpp
@@ -0,0 +1,109 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+
+
+CustomEdit::CustomEdit( TQWidget *parent, const char *name ) : 
+    TQLineEdit( parent, name )
+{
+    connect( this, SIGNAL(textChanged(const TQString &)), 
+	     this, SLOT(changed(const TQString &)) );
+}
+
+
+void CustomEdit::changed( const TQString &line )
+{
+    setUpperLine( line );
+}
+
+
+void CustomEdit::setUpperLine( const TQString &line )
+{
+    upperLineText = line.upper();
+    setText( upperLineText );
+}
+
+
+TQString CustomEdit::upperLine() const 
+{
+    return upperLineText;
+}
+
+
+FormDialog::FormDialog()
+{
+    TQLabel	*forenameLabel	= new TQLabel( "Forename:", this );
+    CustomEdit	*forenameEdit	= new CustomEdit( this );
+    TQLabel	*surnameLabel   = new TQLabel( "Surname:", this );
+    CustomEdit	*surnameEdit	= new CustomEdit( this );
+    TQLabel	*salaryLabel	= new TQLabel( "Salary:", this );
+    TQLineEdit	*salaryEdit	= new TQLineEdit( this );
+    salaryEdit->setAlignment( TQt::AlignRight );
+    TQPushButton *saveButton	= new TQPushButton( "&Save", this );
+    connect( saveButton, SIGNAL(clicked()), this, SLOT(save()) );
+
+    TQGridLayout *grid = new TQGridLayout( this );
+    grid->addWidget( forenameLabel, 0, 0 );
+    grid->addWidget( forenameEdit,  0, 1 );
+    grid->addWidget( surnameLabel,  1, 0 );
+    grid->addWidget( surnameEdit,   1, 1 );
+    grid->addWidget( salaryLabel,   2, 0 );
+    grid->addWidget( salaryEdit,    2, 1 );
+    grid->addWidget( saveButton,    3, 0 );
+    grid->activate();
+
+    staffCursor = new TQSqlCursor( "staff" );
+    staffCursor->setTrimmed( "forename", TRUE );
+    staffCursor->setTrimmed( "surname",  TRUE );
+    idIndex = staffCursor->index( "id" );
+    staffCursor->select( idIndex );
+    staffCursor->first();
+
+    propMap = new TQSqlPropertyMap;
+    propMap->insert( forenameEdit->className(), "upperLine" );
+
+    sqlForm = new TQSqlForm( this );
+    sqlForm->setRecord( staffCursor->primeUpdate() );
+    sqlForm->installPropertyMap( propMap );
+    sqlForm->insert( forenameEdit, "forename" );
+    sqlForm->insert( surnameEdit, "surname" );
+    sqlForm->insert( salaryEdit, "salary" );
+    sqlForm->readFields();
+}
+
+
+FormDialog::~FormDialog()
+{
+    delete staffCursor;
+}
+
+
+void FormDialog::save()
+{
+    sqlForm->writeFields();
+    staffCursor->update();
+    staffCursor->select( idIndex );
+    staffCursor->first();
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( ! createConnections() ) 
+	return 1;
+
+    FormDialog *formDialog = new FormDialog();
+    formDialog->show();
+    app.setMainWidget( formDialog );
+
+    return app.exec();
+}
diff --git a/examples/sql/overview/custom1/main.h b/examples/sql/overview/custom1/main.h
new file mode 100644
index 000000000..191672245
--- /dev/null
+++ b/examples/sql/overview/custom1/main.h
@@ -0,0 +1,52 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qdialog.h>
+#include <qlabel.h>
+#include <qlayout.h>
+#include <qlineedit.h>
+#include <qpushbutton.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qsqlform.h>
+#include <qsqlpropertymap.h>
+#include "../connection.h"
+
+class CustomEdit : public TQLineEdit
+{
+    Q_OBJECT
+    Q_PROPERTY( TQString upperLine READ upperLine WRITE setUpperLine )
+    public:
+	CustomEdit( TQWidget *parent=0, const char *name=0 );
+	TQString upperLine() const;
+	void setUpperLine( const TQString &line );
+    public slots:
+	void changed( const TQString &line );
+    private:
+	TQString upperLineText;
+};
+
+
+class FormDialog : public TQDialog
+{
+    Q_OBJECT
+    public:
+	FormDialog();
+	~FormDialog();
+    public slots:
+	void save();
+    private:
+	TQSqlCursor *staffCursor;
+	TQSqlForm *sqlForm;
+	TQSqlPropertyMap *propMap;
+	TQSqlIndex idIndex;
+};
+
+
diff --git a/examples/sql/overview/delete/README b/examples/sql/overview/delete/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/delete/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/delete/delete.pro b/examples/sql/overview/delete/delete.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/delete/delete.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/delete/main.cpp b/examples/sql/overview/delete/main.cpp
new file mode 100644
index 000000000..ebe2108fa
--- /dev/null
+++ b/examples/sql/overview/delete/main.cpp
@@ -0,0 +1,29 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlCursor cur( "prices" );
+	cur.select( "id=999" );
+	if ( cur.next() ) {
+	    cur.primeDelete();
+	    cur.del();
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/extract/README b/examples/sql/overview/extract/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/extract/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/extract/extract.pro b/examples/sql/overview/extract/extract.pro
new file mode 100644
index 000000000..c517268f4
--- /dev/null
+++ b/examples/sql/overview/extract/extract.pro
@@ -0,0 +1,9 @@
+TEMPLATE 	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	=../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/extract/main.cpp b/examples/sql/overview/extract/main.cpp
new file mode 100644
index 000000000..191601c82
--- /dev/null
+++ b/examples/sql/overview/extract/main.cpp
@@ -0,0 +1,41 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlCursor cur( "creditors" );
+
+	TQStringList orderFields = TQStringList() << "surname" << "forename";
+	TQSqlIndex order = cur.index( orderFields );
+
+	TQStringList filterFields = TQStringList() << "surname" << "city";
+	TQSqlIndex filter = cur.index( filterFields );
+	cur.setValue( "surname", "Chirac" );
+	cur.setValue( "city", "Paris" );
+
+	cur.select( filter, order );
+
+	while ( cur.next() ) {
+	    int id = cur.value( "id" ).toInt();
+	    TQString name = cur.value( "forename" ).toString() + " " +
+			   cur.value( "surname" ).toString();
+	    qDebug( TQString::number( id ) + ": " + name );
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/form1/form1.pro b/examples/sql/overview/form1/form1.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/form1/form1.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/form1/main.cpp b/examples/sql/overview/form1/main.cpp
new file mode 100644
index 000000000..8f1c05b0e
--- /dev/null
+++ b/examples/sql/overview/form1/main.cpp
@@ -0,0 +1,69 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qdialog.h>
+#include <qlabel.h>
+#include <qlayout.h>
+#include <qlineedit.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qsqlform.h>
+#include "../connection.h"
+
+class FormDialog : public TQDialog
+{
+    public:
+	FormDialog();
+};
+
+
+FormDialog::FormDialog()
+{
+    TQLabel *forenameLabel   = new TQLabel( "Forename:", this );
+    TQLabel *forenameDisplay = new TQLabel( this );
+    TQLabel *surnameLabel    = new TQLabel( "Surname:", this );
+    TQLabel *surnameDisplay  = new TQLabel( this );
+    TQLabel *salaryLabel	    = new TQLabel( "Salary:", this );
+    TQLineEdit *salaryEdit   = new TQLineEdit( this );
+
+    TQGridLayout *grid = new TQGridLayout( this );
+    grid->addWidget( forenameLabel,	0, 0 );
+    grid->addWidget( forenameDisplay,	0, 1 );
+    grid->addWidget( surnameLabel,	1, 0 );
+    grid->addWidget( surnameDisplay,	1, 1 );
+    grid->addWidget( salaryLabel,	2, 0 );
+    grid->addWidget( salaryEdit,	2, 1 );
+    grid->activate();
+
+    TQSqlCursor staffCursor( "staff" );
+    staffCursor.select();
+    staffCursor.next();
+
+    TQSqlForm sqlForm( this );
+    sqlForm.setRecord( staffCursor.primeUpdate() );
+    sqlForm.insert( forenameDisplay, "forename" );
+    sqlForm.insert( surnameDisplay, "surname" );
+    sqlForm.insert( salaryEdit, "salary" );
+    sqlForm.readFields();
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( ! createConnections() ) return 1;
+
+    FormDialog *formDialog = new FormDialog();
+    formDialog->show();
+    app.setMainWidget( formDialog );
+
+    return app.exec();
+}
diff --git a/examples/sql/overview/form2/form2.pro b/examples/sql/overview/form2/form2.pro
new file mode 100644
index 000000000..c490bedd0
--- /dev/null
+++ b/examples/sql/overview/form2/form2.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 = main.h
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/form2/main.cpp b/examples/sql/overview/form2/main.cpp
new file mode 100644
index 000000000..2d5420bdc
--- /dev/null
+++ b/examples/sql/overview/form2/main.cpp
@@ -0,0 +1,77 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+
+FormDialog::FormDialog()
+    : staffCursor( "staff" )
+{
+    staffCursor.setTrimmed( "forename", TRUE );
+    staffCursor.setTrimmed( "surname",  TRUE );
+
+    TQLabel	*forenameLabel = new TQLabel( "Forename:", this );
+    TQLineEdit	*forenameEdit  = new TQLineEdit( this );
+    TQLabel	*surnameLabel  = new TQLabel( "Surname:", this );
+    TQLineEdit	*surnameEdit   = new TQLineEdit( this );
+    TQLabel	*salaryLabel   = new TQLabel( "Salary:", this );
+    TQLineEdit	*salaryEdit    = new TQLineEdit( this );
+    TQPushButton *saveButton    = new TQPushButton( "&Save", this );
+    connect( saveButton, SIGNAL(clicked()), this, SLOT(save()) );
+
+    TQGridLayout *grid = new TQGridLayout( this );
+    grid->addWidget( forenameLabel, 0, 0 );
+    grid->addWidget( forenameEdit,  0, 1 );
+    grid->addWidget( surnameLabel,  1, 0 );
+    grid->addWidget( surnameEdit,   1, 1 );
+    grid->addWidget( salaryLabel,   2, 0 );
+    grid->addWidget( salaryEdit,    2, 1 );
+    grid->addWidget( saveButton,    3, 0 );
+    grid->activate();
+
+    idIndex = staffCursor.index( "id" );
+    staffCursor.select( idIndex );
+    staffCursor.first();
+
+    sqlForm = new TQSqlForm( this );
+    sqlForm->setRecord( staffCursor.primeUpdate() );
+    sqlForm->insert( forenameEdit, "forename" );
+    sqlForm->insert( surnameEdit, "surname" );
+    sqlForm->insert( salaryEdit, "salary" );
+    sqlForm->readFields();
+}
+
+
+FormDialog::~FormDialog()
+{
+
+}
+
+
+void FormDialog::save()
+{
+    sqlForm->writeFields();
+    staffCursor.update();
+    staffCursor.select( idIndex );
+    staffCursor.first();
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( ! createConnections() )
+	return 1;
+
+    FormDialog *formDialog = new FormDialog();
+    formDialog->show();
+    app.setMainWidget( formDialog );
+
+    return app.exec();
+}
diff --git a/examples/sql/overview/form2/main.h b/examples/sql/overview/form2/main.h
new file mode 100644
index 000000000..31a0f66cd
--- /dev/null
+++ b/examples/sql/overview/form2/main.h
@@ -0,0 +1,33 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qdialog.h>
+#include <qlabel.h>
+#include <qlayout.h>
+#include <qlineedit.h>
+#include <qpushbutton.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qsqlform.h>
+#include "../connection.h"
+
+class FormDialog : public TQDialog
+{
+    Q_OBJECT
+    public:
+	FormDialog();
+	~FormDialog();
+    public slots:
+	void save();
+    private:
+	TQSqlCursor staffCursor;
+	TQSqlForm *sqlForm;
+	TQSqlIndex idIndex;
+};
diff --git a/examples/sql/overview/insert/README b/examples/sql/overview/insert/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/insert/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/insert/insert.pro b/examples/sql/overview/insert/insert.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/insert/insert.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/insert/main.cpp b/examples/sql/overview/insert/main.cpp
new file mode 100644
index 000000000..47276819f
--- /dev/null
+++ b/examples/sql/overview/insert/main.cpp
@@ -0,0 +1,37 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+    	int count = 0;
+	TQSqlCursor cur( "prices" ); 
+	TQStringList names = TQStringList() <<
+	    "Screwdriver" << "Hammer" << "Wrench" << "Saw";
+	int id = 20;
+	for ( TQStringList::Iterator name = names.begin();
+	      name != names.end(); ++name ) {
+	    TQSqlRecord *buffer = cur.primeInsert();
+	    buffer->setValue( "id", id );
+	    buffer->setValue( "name", *name );
+	    buffer->setValue( "price", 100.0 + (double)id );
+	    count += cur.insert();
+	    id++;
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/insert2/insert2.pro b/examples/sql/overview/insert2/insert2.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/insert2/insert2.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/insert2/main.cpp b/examples/sql/overview/insert2/main.cpp
new file mode 100644
index 000000000..800a94464
--- /dev/null
+++ b/examples/sql/overview/insert2/main.cpp
@@ -0,0 +1,29 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlCursor cur( "prices" ); 
+	TQSqlRecord *buffer = cur.primeInsert();
+	buffer->setValue( "id",	   53981 );
+	buffer->setValue( "name",  "Thingy" );
+	buffer->setValue( "price", 105.75 );
+	cur.insert();
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/navigating/README b/examples/sql/overview/navigating/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/navigating/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/navigating/main.cpp b/examples/sql/overview/navigating/main.cpp
new file mode 100644
index 000000000..519aa2698
--- /dev/null
+++ b/examples/sql/overview/navigating/main.cpp
@@ -0,0 +1,33 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlquery.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlQuery query( "SELECT id, name FROM people ORDER BY name" );
+	if ( ! query.isActive() ) return 1; // Query failed
+	int i;
+	i = query.size();		// In this example we have 9 records; i == 9.
+	query.first();			// Moves to the first record. 
+	i = query.at();			// i == 0
+	query.last();			// Moves to the last record.  
+	i = query.at();			// i == 8
+	query.seek( query.size() / 2 ); // Moves to the middle record. 
+	i = query.at();			// i == 4
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/navigating/navigating.pro b/examples/sql/overview/navigating/navigating.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/navigating/navigating.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/order1/README b/examples/sql/overview/order1/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/order1/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/order1/main.cpp b/examples/sql/overview/order1/main.cpp
new file mode 100644
index 000000000..7b185d459
--- /dev/null
+++ b/examples/sql/overview/order1/main.cpp
@@ -0,0 +1,32 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+        TQSqlCursor cur( "staff" ); 
+        TQStringList fields = TQStringList() << "surname" << "forename";
+        TQSqlIndex order = cur.index( fields );
+        cur.select( order ); 
+        while ( cur.next() ) {
+	    qDebug( cur.value( "id" ).toString() + ": " +
+		    cur.value( "surname" ).toString() + " " +
+		    cur.value( "forename" ).toString() );
+        }
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/order1/order1.pro b/examples/sql/overview/order1/order1.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/order1/order1.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/order2/README b/examples/sql/overview/order2/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/order2/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/order2/main.cpp b/examples/sql/overview/order2/main.cpp
new file mode 100644
index 000000000..9165d2a9f
--- /dev/null
+++ b/examples/sql/overview/order2/main.cpp
@@ -0,0 +1,34 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+   	TQSqlCursor cur( "staff" );
+	TQStringList fields = TQStringList() << "id" << "forename";
+	TQSqlIndex order = cur.index( fields );
+	TQSqlIndex filter = cur.index( "surname" );
+	cur.setValue( "surname", "Bloggs" );
+	cur.select( filter, order ); 
+	while ( cur.next() ) {
+	    qDebug( cur.value( "id" ).toString() + ": " +
+		    cur.value( "surname" ).toString() + " " +
+		    cur.value( "forename" ).toString() );
+        }
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/order2/order2.pro b/examples/sql/overview/order2/order2.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/order2/order2.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/overview.pro b/examples/sql/overview/overview.pro
new file mode 100644
index 000000000..59be65100
--- /dev/null
+++ b/examples/sql/overview/overview.pro
@@ -0,0 +1,33 @@
+TEMPLATE = subdirs
+
+CONFIG 	+= ordered
+
+REQUIRES = full-config
+
+SUBDIRS	 = basicbrowsing \
+	   basicbrowsing2 \
+	   basicdatamanip \
+	   connect1 \
+	   create_connections \
+	   custom1 \
+	   delete \
+	   extract \
+	   form1 \
+	   form2 \
+	   insert \
+	   insert2 \
+	   navigating \
+	   order1 \
+	   order2 \
+	   retrieve1 \
+	   retrieve2 \
+	   subclass1 \
+	   subclass2 \
+	   subclass3 \
+	   subclass4 \
+	   subclass5 \
+	   table1 \
+	   table2 \
+	   table3 \
+	   table4 \
+	   update
diff --git a/examples/sql/overview/retrieve1/README b/examples/sql/overview/retrieve1/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/retrieve1/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/retrieve1/main.cpp b/examples/sql/overview/retrieve1/main.cpp
new file mode 100644
index 000000000..956f8a17f
--- /dev/null
+++ b/examples/sql/overview/retrieve1/main.cpp
@@ -0,0 +1,30 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlquery.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+	TQSqlQuery query( "SELECT id, surname FROM staff" );
+	if ( query.isActive() ) {
+	    while ( query.next() ) {
+		qDebug( query.value(0).toString() + ": " +
+		        query.value(1).toString() );
+	    }
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/retrieve1/retrieve1.pro b/examples/sql/overview/retrieve1/retrieve1.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/retrieve1/retrieve1.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/retrieve2/README b/examples/sql/overview/retrieve2/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/retrieve2/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/retrieve2/main.cpp b/examples/sql/overview/retrieve2/main.cpp
new file mode 100644
index 000000000..4cb0150be
--- /dev/null
+++ b/examples/sql/overview/retrieve2/main.cpp
@@ -0,0 +1,30 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor cur( "staff" ); // Specify the table/view name
+	cur.select(); // We'll retrieve every record
+	while ( cur.next() ) {
+	    qDebug( cur.value( "id" ).toString() + ": " +
+		    cur.value( "surname" ).toString() + " " +
+		    cur.value( "salary" ).toString() );
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/retrieve2/retrieve2.pro b/examples/sql/overview/retrieve2/retrieve2.pro
new file mode 100644
index 000000000..c58585ea2
--- /dev/null
+++ b/examples/sql/overview/retrieve2/retrieve2.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES 	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp
diff --git a/examples/sql/overview/subclass1/main.cpp b/examples/sql/overview/subclass1/main.cpp
new file mode 100644
index 000000000..476ebd898
--- /dev/null
+++ b/examples/sql/overview/subclass1/main.cpp
@@ -0,0 +1,38 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qdatatable.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor invoiceItemCursor( "invoiceitem" );
+
+	TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor );
+
+	app.setMainWidget( invoiceItemTable );
+
+	invoiceItemTable->addColumn( "pricesid", "PriceID" );
+	invoiceItemTable->addColumn( "quantity", "Quantity" );
+	invoiceItemTable->addColumn( "paiddate", "Paid" );
+
+	invoiceItemTable->refresh();
+	invoiceItemTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/subclass1/subclass1.pro b/examples/sql/overview/subclass1/subclass1.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/subclass1/subclass1.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/subclass2/main.cpp b/examples/sql/overview/subclass2/main.cpp
new file mode 100644
index 000000000..f7f9bd91f
--- /dev/null
+++ b/examples/sql/overview/subclass2/main.cpp
@@ -0,0 +1,42 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+#include <qdatatable.h>
+
+InvoiceItemCursor::InvoiceItemCursor() :
+    TQSqlCursor( "invoiceitem" )
+{
+    // NOOP
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	InvoiceItemCursor invoiceItemCursor;
+
+	TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor );
+
+	app.setMainWidget( invoiceItemTable );
+
+	invoiceItemTable->addColumn( "pricesid", "PriceID" );
+	invoiceItemTable->addColumn( "quantity", "Quantity" );
+	invoiceItemTable->addColumn( "paiddate", "Paid" );
+
+	invoiceItemTable->refresh();
+	invoiceItemTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/subclass2/main.h b/examples/sql/overview/subclass2/main.h
new file mode 100644
index 000000000..020ecbff7
--- /dev/null
+++ b/examples/sql/overview/subclass2/main.h
@@ -0,0 +1,23 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+class TQSqlRecord;
+
+class InvoiceItemCursor : public TQSqlCursor
+{
+    public:
+	InvoiceItemCursor();
+};
+
+
diff --git a/examples/sql/overview/subclass2/subclass2.pro b/examples/sql/overview/subclass2/subclass2.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/subclass2/subclass2.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/subclass3/main.cpp b/examples/sql/overview/subclass3/main.cpp
new file mode 100644
index 000000000..db77b855e
--- /dev/null
+++ b/examples/sql/overview/subclass3/main.cpp
@@ -0,0 +1,57 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+#include <qdatatable.h>
+
+InvoiceItemCursor::InvoiceItemCursor() :
+    TQSqlCursor( "invoiceitem" )
+{
+    TQSqlFieldInfo productName( "productname", TQVariant::String );
+    append( productName );
+    setCalculated( productName.name(), TRUE );
+}
+
+
+TQVariant InvoiceItemCursor::calculateField( const TQString & name )
+{
+    if ( name == "productname" ) {
+	TQSqlQuery query( "SELECT name FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return query.value( 0 );
+    }
+
+    return TQVariant( TQString::null );
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	InvoiceItemCursor invoiceItemCursor;
+
+	TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor );
+
+	app.setMainWidget( invoiceItemTable );
+
+	invoiceItemTable->addColumn( "productname", "Product" );
+	invoiceItemTable->addColumn( "quantity",    "Quantity" );
+	invoiceItemTable->addColumn( "paiddate",    "Paid" );
+
+	invoiceItemTable->refresh();
+	invoiceItemTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/subclass3/main.h b/examples/sql/overview/subclass3/main.h
new file mode 100644
index 000000000..06b0a1734
--- /dev/null
+++ b/examples/sql/overview/subclass3/main.h
@@ -0,0 +1,25 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+class TQSqlRecord;
+
+class InvoiceItemCursor : public TQSqlCursor
+{
+    public:
+	InvoiceItemCursor();
+    protected:
+	TQVariant calculateField( const TQString & name );
+};
+
+
diff --git a/examples/sql/overview/subclass3/subclass3.pro b/examples/sql/overview/subclass3/subclass3.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/subclass3/subclass3.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/subclass4/main.cpp b/examples/sql/overview/subclass4/main.cpp
new file mode 100644
index 000000000..a96870e4d
--- /dev/null
+++ b/examples/sql/overview/subclass4/main.cpp
@@ -0,0 +1,81 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+#include <qdatatable.h>
+
+InvoiceItemCursor::InvoiceItemCursor() :
+    TQSqlCursor( "invoiceitem" )
+{
+    TQSqlFieldInfo productName( "productname", TQVariant::String );
+    append( productName );
+    setCalculated( productName.name(), TRUE );
+
+    TQSqlFieldInfo productPrice( "price", TQVariant::Double );
+    append( productPrice );
+    setCalculated( productPrice.name(), TRUE );
+
+    TQSqlFieldInfo productCost( "cost", TQVariant::Double );
+    append( productCost );
+    setCalculated( productCost.name(), TRUE );
+}
+
+
+TQVariant InvoiceItemCursor::calculateField( const TQString & name )
+{
+
+    if ( name == "productname" ) {
+	TQSqlQuery query( "SELECT name FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return query.value( 0 );
+    }
+    else if ( name == "price" ) {
+	TQSqlQuery query( "SELECT price FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return query.value( 0 );
+    }
+    else if ( name == "cost" ) {
+	TQSqlQuery query( "SELECT price FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return TQVariant( query.value( 0 ).toDouble() *
+			     value( "quantity").toDouble() );
+    }
+
+    return TQVariant( TQString::null );
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	InvoiceItemCursor invoiceItemCursor;
+
+	TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor );
+
+	app.setMainWidget( invoiceItemTable );
+
+	invoiceItemTable->addColumn( "productname", "Product" );
+	invoiceItemTable->addColumn( "price",	    "Price" );
+	invoiceItemTable->addColumn( "quantity",    "Quantity" );
+	invoiceItemTable->addColumn( "cost",	    "Cost" );
+	invoiceItemTable->addColumn( "paiddate",    "Paid" );
+
+	invoiceItemTable->refresh();
+	invoiceItemTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/subclass4/main.h b/examples/sql/overview/subclass4/main.h
new file mode 100644
index 000000000..06b0a1734
--- /dev/null
+++ b/examples/sql/overview/subclass4/main.h
@@ -0,0 +1,25 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+class TQSqlRecord;
+
+class InvoiceItemCursor : public TQSqlCursor
+{
+    public:
+	InvoiceItemCursor();
+    protected:
+	TQVariant calculateField( const TQString & name );
+};
+
+
diff --git a/examples/sql/overview/subclass4/subclass4.pro b/examples/sql/overview/subclass4/subclass4.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/subclass4/subclass4.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/subclass5/main.cpp b/examples/sql/overview/subclass5/main.cpp
new file mode 100644
index 000000000..260ddaf2a
--- /dev/null
+++ b/examples/sql/overview/subclass5/main.cpp
@@ -0,0 +1,94 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+#include <qdatatable.h>
+
+InvoiceItemCursor::InvoiceItemCursor() :
+    TQSqlCursor( "invoiceitem" )
+{
+    TQSqlFieldInfo productName( "productname", TQVariant::String );
+    append( productName );
+    setCalculated( productName.name(), TRUE );
+
+    TQSqlFieldInfo productPrice( "price", TQVariant::Double );
+    append( productPrice );
+    setCalculated( productPrice.name(), TRUE );
+
+    TQSqlFieldInfo productCost( "cost", TQVariant::Double );
+    append( productCost );
+    setCalculated( productCost.name(), TRUE );
+}
+
+
+TQVariant InvoiceItemCursor::calculateField( const TQString & name )
+{
+
+    if ( name == "productname" ) {
+	TQSqlQuery query( "SELECT name FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return query.value( 0 );
+    }
+    else if ( name == "price" ) {
+	TQSqlQuery query( "SELECT price FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return query.value( 0 );
+    }
+    else if ( name == "cost" ) {
+	TQSqlQuery query( "SELECT price FROM prices WHERE id=" +
+		     field( "pricesid" )->value().toString() );
+	if ( query.next() )
+	    return TQVariant( query.value( 0 ).toDouble() *
+			     value( "quantity").toDouble() );
+    }
+
+    return TQVariant( TQString::null );
+}
+
+
+TQSqlRecord *InvoiceItemCursor::primeInsert()
+{
+    TQSqlRecord *buffer = editBuffer();
+    TQSqlQuery query( "SELECT NEXTVAL( 'invoiceitem_seq' )" );
+    if ( query.next() )
+	buffer->setValue( "id", query.value( 0 ) );
+    buffer->setValue( "paiddate", TQDate::currentDate() );
+    buffer->setValue( "quantity", 1 );
+
+    return buffer;
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	InvoiceItemCursor invoiceItemCursor;
+
+	TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor );
+
+	app.setMainWidget( invoiceItemTable );
+
+	invoiceItemTable->addColumn( "productname", "Product" );
+	invoiceItemTable->addColumn( "price",	    "Price" );
+	invoiceItemTable->addColumn( "quantity",    "Quantity" );
+	invoiceItemTable->addColumn( "cost",	    "Cost" );
+	invoiceItemTable->addColumn( "paiddate",    "Paid" );
+
+	invoiceItemTable->refresh();
+	invoiceItemTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/subclass5/main.h b/examples/sql/overview/subclass5/main.h
new file mode 100644
index 000000000..6f3a0edca
--- /dev/null
+++ b/examples/sql/overview/subclass5/main.h
@@ -0,0 +1,25 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qdatetime.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+class TQSqlRecord;
+
+class InvoiceItemCursor : public TQSqlCursor
+{
+    public:
+	InvoiceItemCursor();
+	TQSqlRecord *primeInsert();
+    protected:
+	TQVariant calculateField( const TQString & name );
+};
diff --git a/examples/sql/overview/subclass5/subclass5.pro b/examples/sql/overview/subclass5/subclass5.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/subclass5/subclass5.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/table1/main.cpp b/examples/sql/overview/table1/main.cpp
new file mode 100644
index 000000000..c0041a9a2
--- /dev/null
+++ b/examples/sql/overview/table1/main.cpp
@@ -0,0 +1,31 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qdatatable.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor staffCursor( "staff" );
+	TQDataTable *staffTable = new TQDataTable( &staffCursor, TRUE );
+	app.setMainWidget( staffTable );
+	staffTable->refresh();
+	staffTable->show();
+
+	return app.exec();
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/table1/table1.pro b/examples/sql/overview/table1/table1.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/table1/table1.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/table2/main.cpp b/examples/sql/overview/table2/main.cpp
new file mode 100644
index 000000000..79c9993f9
--- /dev/null
+++ b/examples/sql/overview/table2/main.cpp
@@ -0,0 +1,41 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qdatatable.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor staffCursor( "staff" );
+
+	TQDataTable *staffTable = new TQDataTable( &staffCursor );
+
+	app.setMainWidget( staffTable );
+
+	staffTable->addColumn( "forename", "Forename" );
+	staffTable->addColumn( "surname",  "Surname" );
+	staffTable->addColumn( "salary",   "Annual Salary" );
+
+	TQStringList order = TQStringList() << "surname" << "forename";
+	staffTable->setSort( order );
+
+	staffTable->refresh();
+	staffTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/table2/table2.pro b/examples/sql/overview/table2/table2.pro
new file mode 100644
index 000000000..a6cd8cb47
--- /dev/null
+++ b/examples/sql/overview/table2/table2.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 =
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/table3/main.cpp b/examples/sql/overview/table3/main.cpp
new file mode 100644
index 000000000..4b9f2050e
--- /dev/null
+++ b/examples/sql/overview/table3/main.cpp
@@ -0,0 +1,90 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+#include <qdatatable.h>
+
+StatusPicker::StatusPicker( TQWidget *parent, const char *name )
+    : TQComboBox( parent, name )
+{
+    TQSqlCursor cur( "status" );
+    cur.select( cur.index( "name" ) );
+
+    int i = 0;
+    while ( cur.next() ) {
+	insertItem( cur.value( "name" ).toString(), i );
+	index2id[i] = cur.value( "id" ).toInt();
+	i++;
+    }
+}
+
+
+int StatusPicker::statusId() const
+{
+    return index2id[ currentItem() ];
+}
+
+
+void StatusPicker::setStatusId( int statusid )
+{
+    TQMap<int,int>::Iterator it;
+    for ( it = index2id.begin(); it != index2id.end(); ++it ) {
+	if ( it.data() == statusid ) {
+	    setCurrentItem( it.key() );
+	    break;
+	}
+    }
+}
+
+
+
+TQWidget *CustomSqlEditorFactory::createEditor(
+    TQWidget *parent, const TQSqlField *field )
+{
+    if ( field->name() == "statusid" ) {
+	TQWidget *editor = new StatusPicker( parent );
+	return editor;
+    }
+
+    return TQSqlEditorFactory::createEditor( parent, field );
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor staffCursor( "staff" );
+
+	TQDataTable		*staffTable	= new TQDataTable( &staffCursor );
+	TQSqlPropertyMap		*propMap	= new TQSqlPropertyMap();
+	CustomSqlEditorFactory	*editorFactory	= new CustomSqlEditorFactory();
+	propMap->insert( "StatusPicker", "statusid" );
+	staffTable->installPropertyMap( propMap );
+	staffTable->installEditorFactory( editorFactory );
+
+	app.setMainWidget( staffTable );
+
+	staffTable->addColumn( "forename", "Forename" );
+	staffTable->addColumn( "surname",  "Surname" );
+	staffTable->addColumn( "salary",   "Annual Salary" );
+	staffTable->addColumn( "statusid", "Status" );
+
+	TQStringList order = TQStringList() << "surname" << "forename";
+	staffTable->setSort( order );
+
+	staffTable->refresh();
+	staffTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/table3/main.h b/examples/sql/overview/table3/main.h
new file mode 100644
index 000000000..dd0d8d095
--- /dev/null
+++ b/examples/sql/overview/table3/main.h
@@ -0,0 +1,40 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qcombobox.h>
+#include <qmap.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qsqleditorfactory.h>
+#include <qsqlpropertymap.h>
+#include "../connection.h"
+
+class StatusPicker : public TQComboBox
+{
+    Q_OBJECT
+    Q_PROPERTY( int statusid READ statusId WRITE setStatusId )
+    public:
+	StatusPicker( TQWidget *parent=0, const char *name=0 );
+	int statusId() const;
+	void setStatusId( int id );
+    private:
+	TQMap< int, int > index2id;
+};
+
+
+class CustomSqlEditorFactory : public TQSqlEditorFactory
+{
+    Q_OBJECT
+    public:
+	TQWidget *createEditor( TQWidget *parent, const TQSqlField *field );
+};
+
+
+
diff --git a/examples/sql/overview/table3/table3.pro b/examples/sql/overview/table3/table3.pro
new file mode 100644
index 000000000..c490bedd0
--- /dev/null
+++ b/examples/sql/overview/table3/table3.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 = main.h
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/table4/main.cpp b/examples/sql/overview/table4/main.cpp
new file mode 100644
index 000000000..b557b3f1e
--- /dev/null
+++ b/examples/sql/overview/table4/main.cpp
@@ -0,0 +1,109 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include "main.h"
+
+
+StatusPicker::StatusPicker( TQWidget *parent, const char *name )
+    : TQComboBox( parent, name )
+{
+    TQSqlCursor cur( "status" );
+    cur.select( cur.index( "name" ) );
+
+    int i = 0;
+    while ( cur.next() ) {
+	insertItem( cur.value( "name" ).toString(), i );
+	index2id[i] = cur.value( "id" ).toInt();
+	i++;
+    }
+}
+
+
+int StatusPicker::statusId() const
+{
+    return index2id[ currentItem() ];
+}
+
+
+void StatusPicker::setStatusId( int statusid )
+{
+    TQMap<int,int>::Iterator it;
+    for ( it = index2id.begin(); it != index2id.end(); ++it ) {
+	if ( it.data() == statusid ) {
+	    setCurrentItem( it.key() );
+	    break;
+	}
+    }
+}
+
+
+void CustomTable::paintField( TQPainter * p, const TQSqlField* field,
+			      const TQRect & cr, bool b)
+{
+    if ( !field )
+	return;
+    if ( field->name() == "statusid" ) {
+	TQSqlQuery query( "SELECT name FROM status WHERE id=" +
+		     field->value().toString() );
+	TQString text;
+	if ( query.next() ) {
+	    text = query.value( 0 ).toString();
+	}
+	p->drawText( 2,2, cr.width()-4, cr.height()-4, fieldAlignment( field ), text );
+    }
+    else {
+	TQDataTable::paintField( p, field, cr, b) ;
+    }
+}
+
+
+TQWidget *CustomSqlEditorFactory::createEditor(
+    TQWidget *parent, const TQSqlField *field )
+{
+    if ( field->name() == "statusid" ) {
+	TQWidget *editor = new StatusPicker( parent );
+	return editor;
+    }
+
+    return TQSqlEditorFactory::createEditor( parent, field );
+}
+
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv );
+
+    if ( createConnections() ) {
+	TQSqlCursor staffCursor( "staff" );
+
+	CustomTable		*staffTable	= new CustomTable( &staffCursor );
+	TQSqlPropertyMap		*propMap	= new TQSqlPropertyMap();
+	CustomSqlEditorFactory	*editorFactory	= new CustomSqlEditorFactory();
+	propMap->insert( "StatusPicker", "statusid" );
+	staffTable->installPropertyMap( propMap );
+	staffTable->installEditorFactory( editorFactory );
+
+	app.setMainWidget( staffTable );
+
+	staffTable->addColumn( "forename", "Forename" );
+	staffTable->addColumn( "surname",  "Surname" );
+	staffTable->addColumn( "salary",   "Annual Salary" );
+	staffTable->addColumn( "statusid", "Status" );
+
+	TQStringList order = TQStringList() << "surname" << "forename";
+	staffTable->setSort( order );
+
+	staffTable->refresh();
+	staffTable->show();
+
+	return app.exec();
+    }
+
+    return 1;
+}
diff --git a/examples/sql/overview/table4/main.h b/examples/sql/overview/table4/main.h
new file mode 100644
index 000000000..59edfc9d5
--- /dev/null
+++ b/examples/sql/overview/table4/main.h
@@ -0,0 +1,53 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qcombobox.h>
+#include <qmap.h>
+#include <qpainter.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include <qsqleditorfactory.h>
+#include <qsqlpropertymap.h>
+#include <qdatatable.h>
+#include "../connection.h"
+
+class StatusPicker : public TQComboBox
+{
+    Q_OBJECT
+    Q_PROPERTY( int statusid READ statusId WRITE setStatusId )
+public:
+    StatusPicker( TQWidget *parent=0, const char *name=0 );
+    int statusId() const;
+    void setStatusId( int id );
+private:
+    TQMap< int, int > index2id;
+};
+
+
+class CustomTable : public TQDataTable
+{
+    Q_OBJECT
+public:
+    CustomTable( 
+	    TQSqlCursor *cursor, bool autoPopulate = FALSE, 
+	    TQWidget * parent = 0, const char * name = 0 ) : 
+	TQDataTable( cursor, autoPopulate, parent, name ) {}
+    void paintField(
+	    TQPainter * p, const TQSqlField* field, const TQRect & cr, bool );
+
+};
+
+
+class CustomSqlEditorFactory : public TQSqlEditorFactory
+{
+    Q_OBJECT
+public:
+    TQWidget *createEditor( TQWidget *parent, const TQSqlField *field );
+};
diff --git a/examples/sql/overview/table4/table4.pro b/examples/sql/overview/table4/table4.pro
new file mode 100644
index 000000000..c490bedd0
--- /dev/null
+++ b/examples/sql/overview/table4/table4.pro
@@ -0,0 +1,8 @@
+TEMPLATE = app
+
+CONFIG  += qt warn_on release
+
+REQUIRES = full-config
+
+HEADERS	 = main.h
+SOURCES	 = main.cpp ../connection.cpp
diff --git a/examples/sql/overview/update/README b/examples/sql/overview/update/README
new file mode 100644
index 000000000..eae3cd7f9
--- /dev/null
+++ b/examples/sql/overview/update/README
@@ -0,0 +1 @@
+This example is part of the overview in sql.html
diff --git a/examples/sql/overview/update/main.cpp b/examples/sql/overview/update/main.cpp
new file mode 100644
index 000000000..207702c06
--- /dev/null
+++ b/examples/sql/overview/update/main.cpp
@@ -0,0 +1,32 @@
+/****************************************************************************
+**
+** Copyright (C) 1992-2008 Trolltech ASA.  All rights reserved.
+**
+** This file is part of an example program for TQt.  This example
+** program may be used, distributed and modified without limitation.
+**
+*****************************************************************************/
+
+#include <qapplication.h>
+#include <qsqldatabase.h>
+#include <qsqlcursor.h>
+#include "../connection.h"
+
+int main( int argc, char *argv[] )
+{
+    TQApplication app( argc, argv, FALSE );
+
+    if ( createConnections() ) {
+    	TQSqlCursor cur( "prices" ); 
+	cur.select( "id=202" );
+	if ( cur.next() ) {
+	    TQSqlRecord *buffer = cur.primeUpdate();
+	    double price = buffer->value( "price" ).toDouble();
+	    double newprice = price * 1.05;
+	    buffer->setValue( "price", newprice );
+	    cur.update();
+	}
+    }
+
+    return 0;
+}
diff --git a/examples/sql/overview/update/update.pro b/examples/sql/overview/update/update.pro
new file mode 100644
index 000000000..9e6df96c9
--- /dev/null
+++ b/examples/sql/overview/update/update.pro
@@ -0,0 +1,9 @@
+TEMPLATE	= app
+
+CONFIG		+= qt warn_on release
+DEPENDPATH	= ../../../include
+
+REQUIRES	= full-config
+
+HEADERS		=
+SOURCES		= main.cpp ../connection.cpp