From 5fffa30386502b5423e45c2ed5e6af756b11c7b4 Mon Sep 17 00:00:00 2001 From: Michele Calgaro Date: Tue, 28 May 2024 10:17:01 +0900 Subject: Rename nt* sql related files to equivalent tq* Signed-off-by: Michele Calgaro --- doc/html/sql-overview-subclass5-main-cpp.html | 78 +++++++++++++-------------- 1 file changed, 39 insertions(+), 39 deletions(-) (limited to 'doc/html/sql-overview-subclass5-main-cpp.html') diff --git a/doc/html/sql-overview-subclass5-main-cpp.html b/doc/html/sql-overview-subclass5-main-cpp.html index 2740f677a..6a76f303f 100644 --- a/doc/html/sql-overview-subclass5-main-cpp.html +++ b/doc/html/sql-overview-subclass5-main-cpp.html @@ -43,60 +43,60 @@ body { background: #ffffff; color: black; } *****************************************************************************/ #include "main.h" -#include <ntqdatatable.h> +#include <tqdatatable.h> InvoiceItemCursor::InvoiceItemCursor() : - TQSqlCursor( "invoiceitem" ) + TQSqlCursor( "invoiceitem" ) { - TQSqlFieldInfo productName( "productname", TQVariant::String ); - append( productName ); - setCalculated( productName.name(), TRUE ); + TQSqlFieldInfo productName( "productname", TQVariant::String ); + append( productName ); + setCalculated( productName.name(), TRUE ); - TQSqlFieldInfo productPrice( "price", TQVariant::Double ); - append( productPrice ); - setCalculated( productPrice.name(), TRUE ); + TQSqlFieldInfo productPrice( "price", TQVariant::Double ); + append( productPrice ); + setCalculated( productPrice.name(), TRUE ); - TQSqlFieldInfo productCost( "cost", TQVariant::Double ); - append( productCost ); - setCalculated( productCost.name(), TRUE ); + TQSqlFieldInfo productCost( "cost", TQVariant::Double ); + append( productCost ); + setCalculated( productCost.name(), TRUE ); } -TQVariant InvoiceItemCursor::calculateField( const TQString & name ) +TQVariant InvoiceItemCursor::calculateField( const TQString & name ) { if ( name == "productname" ) { - TQSqlQuery query( "SELECT name FROM prices WHERE id=" + - field( "pricesid" )->value().toString() ); - if ( query.next() ) - return query.value( 0 ); + TQSqlQuery query( "SELECT name FROM prices WHERE id=" + + field( "pricesid" )->value().toString() ); + if ( query.next() ) + return query.value( 0 ); } else if ( name == "price" ) { - TQSqlQuery query( "SELECT price FROM prices WHERE id=" + - field( "pricesid" )->value().toString() ); - if ( query.next() ) - return query.value( 0 ); + TQSqlQuery query( "SELECT price FROM prices WHERE id=" + + field( "pricesid" )->value().toString() ); + if ( query.next() ) + return query.value( 0 ); } else if ( name == "cost" ) { - TQSqlQuery query( "SELECT price FROM prices WHERE id=" + - field( "pricesid" )->value().toString() ); - if ( query.next() ) - return TQVariant( query.value( 0 ).toDouble() * - value( "quantity").toDouble() ); + TQSqlQuery query( "SELECT price FROM prices WHERE id=" + + field( "pricesid" )->value().toString() ); + if ( query.next() ) + return TQVariant( query.value( 0 ).toDouble() * + value( "quantity").toDouble() ); } return TQVariant( TQString::null ); } -TQSqlRecord *InvoiceItemCursor::primeInsert() +TQSqlRecord *InvoiceItemCursor::primeInsert() { - TQSqlRecord *buffer = editBuffer(); - TQSqlQuery query( "SELECT NEXTVAL( 'invoiceitem_seq' )" ); - if ( query.next() ) - buffer->setValue( "id", query.value( 0 ) ); - buffer->setValue( "paiddate", TQDate::currentDate() ); - buffer->setValue( "quantity", 1 ); + TQSqlRecord *buffer = editBuffer(); + TQSqlQuery query( "SELECT NEXTVAL( 'invoiceitem_seq' )" ); + if ( query.next() ) + buffer->setValue( "id", query.value( 0 ) ); + buffer->setValue( "paiddate", TQDate::currentDate() ); + buffer->setValue( "quantity", 1 ); return buffer; } @@ -109,17 +109,17 @@ int main( int argc, char *argv[] ) if ( createConnections() ) { InvoiceItemCursor invoiceItemCursor; - TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor ); + TQDataTable *invoiceItemTable = new TQDataTable( &invoiceItemCursor ); app.setMainWidget( invoiceItemTable ); - invoiceItemTable->addColumn( "productname", "Product" ); - invoiceItemTable->addColumn( "price", "Price" ); - invoiceItemTable->addColumn( "quantity", "Quantity" ); - invoiceItemTable->addColumn( "cost", "Cost" ); - invoiceItemTable->addColumn( "paiddate", "Paid" ); + invoiceItemTable->addColumn( "productname", "Product" ); + invoiceItemTable->addColumn( "price", "Price" ); + invoiceItemTable->addColumn( "quantity", "Quantity" ); + invoiceItemTable->addColumn( "cost", "Cost" ); + invoiceItemTable->addColumn( "paiddate", "Paid" ); - invoiceItemTable->refresh(); + invoiceItemTable->refresh(); invoiceItemTable->show(); return app.exec(); -- cgit v1.2.3