blob: 1cb2f0b9cf66d7d1ff3f1a608ae8089c3df0b91f (
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
|
void BookForm::editClicked()
{
EditBookForm *dialog = new EditBookForm( this, "Edit Book Form", TRUE );
TQSqlCursor cur( "book" );
dialog->BookDataBrowser->setSqlCursor( &cur );
dialog->BookDataBrowser->setFilter( BookDataTable->filter() );
dialog->BookDataBrowser->setSort(TQSqlIndex::fromStringList(
BookDataTable->sort(), &cur ) );
dialog->BookDataBrowser->refresh();
int i = BookDataTable->currentRow();
if ( i == -1 ) i = 0; // Always use the first row
dialog->BookDataBrowser->seek( i );
dialog->exec();
delete dialog;
BookDataTable->refresh();
}
void BookForm::newCurrentAuthor( TQSqlRecord *author )
{
BookDataTable->setFilter( "authorid=" + author->value( "id" ).toString() );
BookDataTable->refresh();
}
void BookForm::primeInsertAuthor( TQSqlRecord *buffer )
{
TQSqlQuery query;
query.exec( "UPDATE sequence SET sequence = sequence + 1 WHERE tablename='author';" );
query.exec( "SELECT sequence FROM sequence WHERE tablename='author';" );
if ( query.next() ) {
buffer->setValue( "id", query.value( 0 ) );
}
}
|
