1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
|
'\" t
.TH QSqlRecord 3qt "2 February 2007" "Trolltech AS" \" -*- nroff -*-
.\" Copyright 1992-2007 Trolltech ASA. All rights reserved. See the
.\" license file included in the distribution for a complete license
.\" statement.
.\"
.ad l
.nh
.SH NAME
QSqlRecord \- Encapsulates a database record, i.e. a set of database fields
.SH SYNOPSIS
\fC#include <qsqlrecord.h>\fR
.PP
Inherited by QSqlCursor and QSqlIndex.
.PP
.SS "Public Members"
.in +1c
.ti -1c
.BI "\fBQSqlRecord\fR ()"
.br
.ti -1c
.BI "\fBQSqlRecord\fR ( const QSqlRecord & other )"
.br
.ti -1c
.BI "QSqlRecord & \fBoperator=\fR ( const QSqlRecord & other )"
.br
.ti -1c
.BI "virtual \fB~QSqlRecord\fR ()"
.br
.ti -1c
.BI "virtual QVariant \fBvalue\fR ( int i ) const"
.br
.ti -1c
.BI "virtual QVariant \fBvalue\fR ( const QString & name ) const"
.br
.ti -1c
.BI "virtual void \fBsetValue\fR ( int i, const QVariant & val )"
.br
.ti -1c
.BI "virtual void \fBsetValue\fR ( const QString & name, const QVariant & val )"
.br
.ti -1c
.BI "bool \fBisGenerated\fR ( int i ) const"
.br
.ti -1c
.BI "bool \fBisGenerated\fR ( const QString & name ) const"
.br
.ti -1c
.BI "virtual void \fBsetGenerated\fR ( const QString & name, bool generated )"
.br
.ti -1c
.BI "virtual void \fBsetGenerated\fR ( int i, bool generated )"
.br
.ti -1c
.BI "virtual void \fBsetNull\fR ( int i )"
.br
.ti -1c
.BI "virtual void \fBsetNull\fR ( const QString & name )"
.br
.ti -1c
.BI "bool \fBisNull\fR ( int i ) const"
.br
.ti -1c
.BI "bool \fBisNull\fR ( const QString & name ) const"
.br
.ti -1c
.BI "int \fBposition\fR ( const QString & name ) const"
.br
.ti -1c
.BI "QString \fBfieldName\fR ( int i ) const"
.br
.ti -1c
.BI "QSqlField * \fBfield\fR ( int i )"
.br
.ti -1c
.BI "QSqlField * \fBfield\fR ( const QString & name )"
.br
.ti -1c
.BI "const QSqlField * \fBfield\fR ( int i ) const"
.br
.ti -1c
.BI "const QSqlField * \fBfield\fR ( const QString & name ) const"
.br
.ti -1c
.BI "virtual void \fBappend\fR ( const QSqlField & field )"
.br
.ti -1c
.BI "virtual void \fBinsert\fR ( int pos, const QSqlField & field )"
.br
.ti -1c
.BI "virtual void \fBremove\fR ( int pos )"
.br
.ti -1c
.BI "bool \fBisEmpty\fR () const"
.br
.ti -1c
.BI "bool \fBcontains\fR ( const QString & name ) const"
.br
.ti -1c
.BI "virtual void \fBclear\fR ()"
.br
.ti -1c
.BI "virtual void \fBclearValues\fR ( bool nullify = FALSE )"
.br
.ti -1c
.BI "uint \fBcount\fR () const"
.br
.ti -1c
.BI "virtual QString \fBtoString\fR ( const QString & prefix = QString::null, const QString & sep = "","" ) const"
.br
.ti -1c
.BI "virtual QStringList \fBtoStringList\fR ( const QString & prefix = QString::null ) const"
.br
.in -1c
.SH DESCRIPTION
The QSqlRecord class encapsulates a database record, i.e. a set of database fields.
.PP
The QSqlRecord class encapsulates the functionality and characteristics of a database record (usually a table or view within the database). QSqlRecords support adding and removing fields as well as setting and retrieving field values.
.PP
QSqlRecord is implicitly shared. This means you can make copies of the record in time O(1). If multiple QSqlRecord instances share the same data and one is modifying the record's data then this modifying instance makes a copy and modifies its private copy - thus it does not affect other instances.
.PP
See also QSqlRecordInfo and Database Classes.
.SH MEMBER FUNCTION DOCUMENTATION
.SH "QSqlRecord::QSqlRecord ()"
Constructs an empty record.
.SH "QSqlRecord::QSqlRecord ( const QSqlRecord & other )"
Constructs a copy of \fIother\fR.
.SH "QSqlRecord::~QSqlRecord ()\fC [virtual]\fR"
Destroys the object and frees any allocated resources.
.SH "void QSqlRecord::append ( const QSqlField & field )\fC [virtual]\fR"
Append a copy of field \fIfield\fR to the end of the record.
.PP
Reimplemented in QSqlIndex.
.SH "void QSqlRecord::clear ()\fC [virtual]\fR"
Removes all the record's fields.
.PP
See also clearValues().
.PP
Reimplemented in QSqlCursor.
.SH "void QSqlRecord::clearValues ( bool nullify = FALSE )\fC [virtual]\fR"
Clears the value of all fields in the record. If \fInullify\fR is TRUE, (the default is FALSE), each field is set to NULL.
.SH "bool QSqlRecord::contains ( const QString & name ) const"
Returns TRUE if there is a field in the record called \fIname\fR; otherwise returns FALSE.
.SH "uint QSqlRecord::count () const"
Returns the number of fields in the record.
.SH "QSqlField * QSqlRecord::field ( int i )"
Returns the field at position \fIi\fR within the record, or 0 if it cannot be found.
.SH "QSqlField * QSqlRecord::field ( const QString & name )"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Returns the field called \fIname\fR within the record, or 0 if it cannot be found. Field names are not case-sensitive.
.SH "const QSqlField * QSqlRecord::field ( int i ) const"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.SH "const QSqlField * QSqlRecord::field ( const QString & name ) const"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Returns the field called \fIname\fR within the record, or 0 if it cannot be found. Field names are not case-sensitive.
.SH "QString QSqlRecord::fieldName ( int i ) const"
Returns the name of the field at position \fIi\fR. If the field does not exist, QString::null is returned.
.SH "void QSqlRecord::insert ( int pos, const QSqlField & field )\fC [virtual]\fR"
Insert a copy of \fIfield\fR at position \fIpos\fR. If a field already exists at \fIpos\fR, it is removed.
.SH "bool QSqlRecord::isEmpty () const"
Returns TRUE if there are no fields in the record; otherwise returns FALSE.
.SH "bool QSqlRecord::isGenerated ( const QString & name ) const"
Returns TRUE if the record has a field called \fIname\fR and this field is to be generated (the default); otherwise returns FALSE.
.PP
See also setGenerated().
.SH "bool QSqlRecord::isGenerated ( int i ) const"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Returns TRUE if the record has a field at position \fIi\fR and this field is to be generated (the default); otherwise returns FALSE.
.PP
See also setGenerated().
.SH "bool QSqlRecord::isNull ( const QString & name ) const"
Returns TRUE if the field called \fIname\fR is NULL or if there is no field called \fIname\fR; otherwise returns FALSE.
.PP
See also position().
.SH "bool QSqlRecord::isNull ( int i ) const"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Returns TRUE if the field \fIi\fR is NULL or if there is no field at position \fIi\fR; otherwise returns FALSE.
.PP
See also fieldName().
.SH "QSqlRecord & QSqlRecord::operator= ( const QSqlRecord & other )"
Sets the record equal to \fIother\fR.
.SH "int QSqlRecord::position ( const QString & name ) const"
Returns the position of the field called \fIname\fR within the record, or -1 if it cannot be found. Field names are not case-sensitive. If more than one field matches, the first one is returned.
.SH "void QSqlRecord::remove ( int pos )\fC [virtual]\fR"
Removes the field at \fIpos\fR. If \fIpos\fR does not exist, nothing happens.
.PP
Reimplemented in QSqlCursor.
.SH "void QSqlRecord::setGenerated ( const QString & name, bool generated )\fC [virtual]\fR"
Sets the generated flag for the field called \fIname\fR to \fIgenerated\fR. If the field does not exist, nothing happens. Only fields that have \fIgenerated\fR set to TRUE are included in the SQL that is generated, e.g. by QSqlCursor.
.PP
See also isGenerated().
.PP
Reimplemented in QSqlCursor.
.SH "void QSqlRecord::setGenerated ( int i, bool generated )\fC [virtual]\fR"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Sets the generated flag for the field \fIi\fR to \fIgenerated\fR.
.PP
See also isGenerated().
.PP
Reimplemented in QSqlCursor.
.SH "void QSqlRecord::setNull ( int i )\fC [virtual]\fR"
Sets the value of field \fIi\fR to NULL. If the field does not exist, nothing happens.
.SH "void QSqlRecord::setNull ( const QString & name )\fC [virtual]\fR"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Sets the value of the field called \fIname\fR to NULL. If the field does not exist, nothing happens.
.SH "void QSqlRecord::setValue ( int i, const QVariant & val )\fC [virtual]\fR"
Sets the value of the field at position \fIi\fR to \fIval\fR. If the field does not exist, nothing happens.
.PP
Examples:
.)l sql/overview/insert/main.cpp, sql/overview/insert2/main.cpp, sql/overview/subclass5/main.cpp, sql/overview/update/main.cpp, and sql/sqltable/main.cpp.
.SH "void QSqlRecord::setValue ( const QString & name, const QVariant & val )\fC [virtual]\fR"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Sets the value of the field called \fIname\fR to \fIval\fR. If the field does not exist, nothing happens.
.SH "QString QSqlRecord::toString ( const QString & prefix = QString::null, const QString & sep = "," ) const\fC [virtual]\fR"
Returns a list of all the record's field names as a string separated by \fIsep\fR.
.PP
Note that fields which are not generated are \fInot\fR included (see isGenerated()). The returned string is suitable, for example, for generating SQL SELECT statements. If a \fIprefix\fR is specified, e.g. a table name, all fields are prefixed in the form:
.PP"
\fIprefix\fR.<fieldname>"
.SH "QStringList QSqlRecord::toStringList ( const QString & prefix = QString::null ) const\fC [virtual]\fR"
Returns a list of all the record's field names, each having the prefix \fIprefix\fR.
.PP
Note that fields which have generated set to FALSE are \fInot\fR included. (See isGenerated()). If \fIprefix\fR is supplied, e.g. a table name, all fields are prefixed in the form:
.PP"
\fIprefix\fR.<fieldname>"
.SH "QVariant QSqlRecord::value ( int i ) const\fC [virtual]\fR"
Returns the value of the field located at position \fIi\fR in the record. If field \fIi\fR does not exist the resultant behaviour is undefined.
.PP
This function should be used with QSqlQuerys. When working with a QSqlCursor the value(const QString&) overload which uses field names is more appropriate.
.PP
Example: sql/overview/update/main.cpp.
.SH "QVariant QSqlRecord::value ( const QString & name ) const\fC [virtual]\fR"
This is an overloaded member function, provided for convenience. It behaves essentially like the above function.
.PP
Returns the value of the field called \fIname\fR in the record. If
field \fIname\fR does not exist the resultant behaviour is undefined.
.SH "SEE ALSO"
.BR http://doc.trolltech.com/qsqlrecord.html
.BR http://www.trolltech.com/faq/tech.html
.SH COPYRIGHT
Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the
license file included in the distribution for a complete license
statement.
.SH AUTHOR
Generated automatically from the source code.
.SH BUGS
If you find a bug in Qt, please report it as described in
.BR http://doc.trolltech.com/bughowto.html .
Good bug reports help us to help you. Thank you.
.P
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.
.P
If you find errors in this manual page, please report them to
.BR qt-bugs@trolltech.com .
Please include the name of the manual page (qsqlrecord.3qt) and the Qt
version (3.3.8).
|