blob: 0bedf8bb2e38a7e817ee1e57311f0c5d9a83cb94 (
plain)
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
|
void EditBookForm::init()
{
TQSqlQuery query( "SELECT surname FROM author ORDER BY surname;" );
while ( query.next() )
ComboBoxAuthor->insertItem( query.value( 0 ).toString());
}
void EditBookForm::beforeUpdateBook( TQSqlRecord * buffer )
{
TQSqlQuery query( "SELECT id FROM author WHERE surname ='" +
ComboBoxAuthor->currentText() + "';" );
if ( query.next() )
buffer->setValue( "authorid", query.value( 0 ) );
}
void EditBookForm::primeInsertBook( TQSqlRecord * buffer )
{
TQSqlQuery query;
query.exec( "UPDATE sequence SET sequence = sequence + 1 WHERE tablename='book';" );
query.exec( "SELECT sequence FROM sequence WHERE tablename='book';" );
if ( query.next() ) {
buffer->setValue( "id", query.value( 0 ) );
}
}
void EditBookForm::primeUpdateBook( TQSqlRecord * buffer )
{
// Who is this book's author?
TQSqlQuery query( "SELECT surname FROM author WHERE id='" +
buffer->value( "authorid" ).toString() + "';" );
TQString author = "";
if ( query.next() )
author = query.value( 0 ).toString();
// Set the ComboBox to the right author
for ( int i = 0; i < ComboBoxAuthor->count(); i++ ) {
if ( ComboBoxAuthor->text( i ) == author ) {
ComboBoxAuthor->setCurrentItem( i ) ;
break;
}
}
}
|
