Viadeo Twitter Google Bookmarks ! Facebook Digg del.icio.us MySpace Yahoo MyWeb Blinklist Netvouz Reddit Simpy StumbleUpon Bookmarks Windows Live Favorites 
Logo Documentation Qt ·  Page d'accueil  ·  Toutes les classes  ·  Toutes les fonctions  ·  Vues d'ensemble  · 

Q3SqlFieldInfo Class Reference

The Q3SqlFieldInfo class stores meta data associated with a SQL field. More...

 #include <Q3SqlFieldInfo>

This class is part of the Qt 3 support library. It is provided to keep old source code working. We strongly advise against using it in new code. See Porting to Qt 4 for more information.

Public Functions

Q3SqlFieldInfo ( const QString & name = QString(), QVariant::Type typ = QVariant::Invalid, int required = -1, int len = -1, int prec = -1, const QVariant & defValue = QVariant(), int typeID = 0, bool generated = true, bool trim = false, bool calculated = false )
Q3SqlFieldInfo ( const QSqlField & other )
virtual ~Q3SqlFieldInfo ()
QVariant defaultValue () const
bool isCalculated () const
bool isGenerated () const
int isRequired () const
bool isTrim () const
int length () const
QString name () const
int precision () const
virtual void setCalculated ( bool calculated )
virtual void setGenerated ( bool generated )
virtual void setTrim ( bool trim )
QSqlField toField () const
QVariant::Type type () const
int typeID () const
bool operator== ( const Q3SqlFieldInfo & other ) const

Detailed Description

The Q3SqlFieldInfo class stores meta data associated with a SQL field.

Q3SqlFieldInfo objects only store meta data; field values are stored in QSqlField objects.

All values must be set in the constructor, and may be retrieved using isRequired(), type(), length(), precision(), defaultValue(), name(), isGenerated() and typeID().

See also Q3SqlRecordInfo.

Member Function Documentation

Q3SqlFieldInfo::Q3SqlFieldInfo ( const QString & name = QString(), QVariant::Type typ = QVariant::Invalid, int required = -1, int len = -1, int prec = -1, const QVariant & defValue = QVariant(), int typeID = 0, bool generated = true, bool trim = false, bool calculated = false )

Constructs a Q3SqlFieldInfo with the following parameters:

namethe name of the field.
typthe field's type in a QVariant.
requiredgreater than 0 if the field is required, 0 if its value can be NULL and less than 0 if it cannot be determined whether the field is required or not.
lenthe length of the field. Note that for non-character types some databases return either the length in bytes or the number of digits. -1 signifies that the length cannot be determined.
precthe precision of the field, or -1 if the field has no precision or it cannot be determined.
defValuethe default value that is inserted into the table if none is specified by the user. QVariant() if there is no default value or it cannot be determined.
typeIDthe internal typeID of the database system (only useful for low-level programming). 0 if unknown.
generatedTRUE indicates that this field should be included in auto-generated SQL statments, e.g. in Q3SqlCursor.
trimTRUE indicates that widgets should remove trailing whitespace from character fields. This does not affect the field value but only its representation inside widgets.
calculatedTRUE indicates that the value of this field is calculated. The value of calculated fields can by modified by subclassing Q3SqlCursor and overriding Q3SqlCursor::calculateField().

Q3SqlFieldInfo::Q3SqlFieldInfo ( const QSqlField & other )

Creates a Q3SqlFieldInfo object with the type and the name of the QSqlField other.

Q3SqlFieldInfo::~Q3SqlFieldInfo () [virtual]

Destroys the object and frees any allocated resources.

QVariant Q3SqlFieldInfo::defaultValue () const

Returns the field's default value or an empty QVariant if the field has no default value or the value couldn't be determined. The default value is the value inserted in the database when it is not explicitly specified by the user.

bool Q3SqlFieldInfo::isCalculated () const

Returns TRUE if the field is calculated; otherwise returns FALSE.

See also setCalculated().

bool Q3SqlFieldInfo::isGenerated () const

Returns TRUE if the field should be included in auto-generated SQL statments, e.g. in Q3SqlCursor; otherwise returns FALSE.

See also setGenerated().

int Q3SqlFieldInfo::isRequired () const

Returns a value greater than 0 if the field is required (NULL values are not allowed), 0 if it isn't required (NULL values are allowed) or less than 0 if it cannot be determined whether the field is required or not.

bool Q3SqlFieldInfo::isTrim () const

Returns TRUE if trailing whitespace should be removed from character fields; otherwise returns FALSE.

See also setTrim().

int Q3SqlFieldInfo::length () const

Returns the field's length. For fields storing text the return value is the maximum number of characters the field can hold. For non-character fields some database systems return the number of bytes needed or the number of digits allowed. If the length cannot be determined -1 is returned.

QString Q3SqlFieldInfo::name () const

Returns the name of the field in the SQL table.

int Q3SqlFieldInfo::precision () const

Returns the field's precision or -1 if the field has no precision or it cannot be determined.

void Q3SqlFieldInfo::setCalculated ( bool calculated ) [virtual]

calculated set to TRUE indicates that this field is a calculated field. The value of calculated fields can by modified by subclassing Q3SqlCursor and overriding Q3SqlCursor::calculateField().

See also isCalculated().

void Q3SqlFieldInfo::setGenerated ( bool generated ) [virtual]

generated set to FALSE indicates that this field should not appear in auto-generated SQL statements (for example in Q3SqlCursor).

See also isGenerated().

void Q3SqlFieldInfo::setTrim ( bool trim ) [virtual]

If trim is TRUE widgets should remove trailing whitespace from character fields. This does not affect the field value but only its representation inside widgets.

See also isTrim().

QSqlField Q3SqlFieldInfo::toField () const

Returns an empty QSqlField based on the information in this Q3SqlFieldInfo.

QVariant::Type Q3SqlFieldInfo::type () const

Returns the field's type or QVariant::Invalid if the type is unknown.

int Q3SqlFieldInfo::typeID () const

Returns the internal type identifier as returned from the database system. The return value is 0 if the type is unknown.

bool Q3SqlFieldInfo::operator== ( const Q3SqlFieldInfo & other ) const

Assigns other to this field info and returns a reference to it.

Publicité

Best Of

Actualités les plus lues

Semaine
Mois
Année
  1. « Quelque chose ne va vraiment pas avec les développeurs "modernes" », un développeur à "l'ancienne" critique la multiplication des bibliothèques 78
  2. Apercevoir la troisième dimension ou l'utilisation multithreadée d'OpenGL dans Qt, un article des Qt Quarterly traduit par Guillaume Belz 0
  3. Les développeurs ignorent-ils trop les failles découvertes dans leur code ? Prenez-vous en compte les remarques des autres ? 17
  4. BlackBerry 10 : premières images du prochain OS de RIM qui devrait intégrer des widgets et des tuiles inspirées de Windows Phone 0
  5. Quelles nouveautés de C++11 Visual C++ doit-il rapidement intégrer ? Donnez-nous votre avis 10
  6. Adieu qmake, bienvenue qbs : Qt Building Suite, un outil déclaratif et extensible pour la compilation de projets Qt 17
  7. 2017 : un quinquennat pour une nouvelle version du C++ ? Possible, selon Herb Sutter 6
Page suivante

Le Qt Quarterly au hasard

Logo

Les aventures de QLALR - utiliser QLALR pour générer un parseur pour une aventure textuelle

Qt Quarterly est la revue trimestrielle proposée par Nokia et à destination des développeurs Qt. Ces articles d'une grande qualité technique sont rédigés par des experts Qt. Lire l'article.

Communauté

Ressources

Liens utiles

Contact

  • Vous souhaitez rejoindre la rédaction ou proposer un tutoriel, une traduction, une question... ? Postez dans le forum Contribuez ou contactez-nous par MP ou par email (voir en bas de page).

Qt dans le magazine

Cette page est une traduction d'une page de la documentation de Qt, écrite par Nokia Corporation and/or its subsidiary(-ies). Les éventuels problèmes résultant d'une mauvaise traduction ne sont pas imputables à Nokia. Qt 4.7-snapshot
Copyright © 2012 Developpez LLC. Tous droits réservés Developpez LLC. Aucune reproduction, même partielle, ne peut être faite de ce site et de l'ensemble de son contenu : textes, documents et images sans l'autorisation expresse de Developpez LLC. Sinon, vous encourez selon la loi jusqu'à 3 ans de prison et jusqu'à 300 000 E de dommages et intérêts. Cette page est déposée à la SACD.
Vous avez déniché une erreur ? Un bug ? Une redirection cassée ? Ou tout autre problème, quel qu'il soit ? Ou bien vous désirez participer à ce projet de traduction ? N'hésitez pas à nous contacter ou par MP !
 
 
 
 
Partenaires

Hébergement Web