NAME¶

QSqlPropertyMap - Used to map widgets to SQL fields

SYNOPSIS¶

#include <qsqlpropertymap.h>

DESCRIPTION¶

The QSqlPropertyMap class is used to map widgets to SQL fields.

The SQL module uses Qt object properties to insert and extract values from editor widgets.

This class is used to map editors to SQL fields. This works by associating SQL editor class names to the properties used to insert and extract values to/from the editor.

For example, a QLineEdit can be used to edit text strings and other data types in QDataTables or QSqlForms. Several properties are defined in QLineEdit, but only the text property is used to insert and extract text from a QLineEdit. Both QDataTable and QSqlForm use the global QSqlPropertyMap for inserting and extracting values to and from an editor widget. The global property map defines several common widgets and properties that are suitable for many applications. You can add and remove widget properties to suit your specific needs.

If you want to use custom editors with your QDataTable or QSqlForm, you must install your own QSqlPropertyMap for that table or form. Example:

    QSqlPropertyMap *myMap  = new QSqlPropertyMap();


    QSqlForm        *myForm = new QSqlForm( this );


    MyEditor myEditor( this );




    // Set the QSqlForm's record buffer to the update buffer of


    // a pre-existing QSqlCursor called 'cur'.


    myForm->setRecord( cur->primeUpdate() );




    // Install the customized map


    myMap->insert( "MyEditor", "content" );


    myForm->installPropertyMap( myMap ); // myForm now owns myMap


    ...


    // Insert a field into the form that uses a myEditor to edit the


    // field 'somefield'


    myForm->insert( &myEditor, "somefield" );




    // Update myEditor with the value from the mapped database field


    myForm->readFields();


    ...


    // Let the user edit the form


    ...


    // Update the database fields with the values in the form


    myForm->writeFields();


    ...

You can also replace the global QSqlPropertyMap that is used by default. (Bear in mind that QSqlPropertyMap takes ownership of the new default map.)

    QSqlPropertyMap *myMap = new QSqlPropertyMap;




    myMap->insert( "MyEditor", "content" );


    QSqlPropertyMap::installDefaultMap( myMap );


    ...

See also QDataTable, QSqlForm, QSqlEditorFactory, and Database Classes.

MEMBER FUNCTION DOCUMENTATION¶

QSqlPropertyMap::QSqlPropertyMap ()¶

Constructs a QSqlPropertyMap.

The default property mappings used by Qt widgets are: <center>.nf

</center>

QSqlPropertyMap::~QSqlPropertyMap () [virtual]¶

Destroys the QSqlPropertyMap.

Note that if the QSqlPropertyMap is installed with installPropertyMap() the object it was installed into, e.g. the QSqlForm, takes ownership and will delete the QSqlPropertyMap when necessary.

QSqlPropertyMap * QSqlPropertyMap::defaultMap () [static]¶

Returns the application global QSqlPropertyMap.

void QSqlPropertyMap::insert ( const QString & classname, const QString & property )¶

Insert a new classname/property pair, which is used for custom SQL field editors. There must be a Q_PROPERTY clause in the classname class declaration for the property.

Example: sql/overview/custom1/main.cpp.

void QSqlPropertyMap::installDefaultMap ( QSqlPropertyMap * map ) [static]¶

Replaces the global default property map with map. All QDataTable and QSqlForm instantiations will use this new map for inserting and extracting values to and from editors. QSqlPropertyMap takes ownership of &#92;a map, and destroys it when it is no longer needed.

QVariant QSqlPropertyMap::property ( QWidget * widget )¶

Returns the mapped property of widget as a QVariant.

void QSqlPropertyMap::remove ( const QString & classname )¶

Removes classname from the map.

void QSqlPropertyMap::setProperty ( QWidget * widget, const QVariant & value ) [virtual]¶

Sets the property of widget to value.

SEE ALSO¶

http://doc.trolltech.com/qsqlpropertymap.html http://www.trolltech.com/faq/tech.html

COPYRIGHT¶

Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the license file included in the distribution for a complete license statement.

AUTHOR¶

Generated automatically from the source code.

BUGS¶

If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you.

The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech.

If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qsqlpropertymap.3qt) and the Qt version (3.3.8).