<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
< html >
< head >
< meta http-equiv = "Content-Type" content = "text/html; charset=ISO-8859-1" >
< title > sql/overview/subclass5/main.cpp Example File< / title >
< style type = "text/css" > < ! - -
fn { margin-left: 1cm; text-indent: -1cm; }
a:link { color: #004faf; text-decoration: none }
a:visited { color: #672967; text-decoration: none }
body { background: #ffffff; color: black; }
-->< / style >
< / head >
< body >
< table border = "0" cellpadding = "0" cellspacing = "0" width = "100%" >
< tr bgcolor = "#E5E5E5" >
< td valign = center >
< a href = "index.html" >
< font color = "#004faf" > Home< / font > < / a >
| < a href = "classes.html" >
< font color = "#004faf" > All Classes< / font > < / a >
| < a href = "mainclasses.html" >
< font color = "#004faf" > Main Classes< / font > < / a >
| < a href = "annotated.html" >
< font color = "#004faf" > Annotated< / font > < / a >
| < a href = "groups.html" >
< font color = "#004faf" > Grouped Classes< / font > < / a >
| < a href = "functions.html" >
< font color = "#004faf" > Functions< / font > < / a >
< / td >
< td align = "right" valign = "center" > < img src = "logo32.png" align = "right" width = "64" height = "32" border = "0" > < / td > < / tr > < / table > < h1 align = center > sql/overview/subclass5/main.cpp Example File< / h1 >
< pre > /****************************************************************************
** $Id: qt/main.cpp 3.3.8 edited Jan 11 14:37 $
**
** Copyright (C) 1992-2007 Trolltech ASA. All rights reserved.
**
** This file is part of an example program for TQt. This example
** program may be used, distributed and modified without limitation.
**
*****************************************************************************/
#include "main.h"
#include < < a href = "tqdatatable-h.html" > tqdatatable.h< / a > >
< a name = "f25" > < / a > InvoiceItemCursor::InvoiceItemCursor() :
< a href = "tqsqlcursor.html" > TQSqlCursor< / a > ( "invoiceitem" )
{
< a href = "tqsqlfieldinfo.html" > TQSqlFieldInfo< / a > productName( "productname", TQVariant::String );
< a href = "tqsqlcursor.html#append" > append< / a > ( productName );
< a href = "tqsqlcursor.html#setCalculated" > setCalculated< / a > ( productName.< a href = "tqsqlfieldinfo.html#name" > name< / a > (), TRUE );
< a href = "tqsqlfieldinfo.html" > TQSqlFieldInfo< / a > productPrice( "price", TQVariant::Double );
< a href = "tqsqlcursor.html#append" > append< / a > ( productPrice );
< a href = "tqsqlcursor.html#setCalculated" > setCalculated< / a > ( productPrice.< a href = "tqsqlfieldinfo.html#name" > name< / a > (), TRUE );
< a href = "tqsqlfieldinfo.html" > TQSqlFieldInfo< / a > productCost( "cost", TQVariant::Double );
< a href = "tqsqlcursor.html#append" > append< / a > ( productCost );
< a href = "tqsqlcursor.html#setCalculated" > setCalculated< / a > ( productCost.< a href = "tqsqlfieldinfo.html#name" > name< / a > (), TRUE );
}
TQVariant InvoiceItemCursor::< a href = "tqsqlcursor.html#calculateField" > calculateField< / a > ( const < a href = "tqstring.html" > TQString< / a > & name )
{
if ( name == "productname" ) {
< a href = "tqsqlquery.html" > TQSqlQuery< / a > query( "SELECT name FROM prices WHERE id=" +
< a href = "tqsqlrecord.html#field" > field< / a > ( "pricesid" )-> value().toString() );
if ( query.< a href = "tqsqlquery.html#next" > next< / a > () )
return query.< a href = "tqsqlquery.html#value" > value< / a > ( 0 );
}
else if ( name == "price" ) {
< a href = "tqsqlquery.html" > TQSqlQuery< / a > query( "SELECT price FROM prices WHERE id=" +
< a href = "tqsqlrecord.html#field" > field< / a > ( "pricesid" )-> value().toString() );
if ( query.< a href = "tqsqlquery.html#next" > next< / a > () )
return query.< a href = "tqsqlquery.html#value" > value< / a > ( 0 );
}
else if ( name == "cost" ) {
< a href = "tqsqlquery.html" > TQSqlQuery< / a > query( "SELECT price FROM prices WHERE id=" +
< a href = "tqsqlrecord.html#field" > field< / a > ( "pricesid" )-> value().toString() );
if ( query.< a href = "tqsqlquery.html#next" > next< / a > () )
return TQVariant( query.< a href = "tqsqlquery.html#value" > value< / a > ( 0 ).toDouble() *
< a href = "tqsqlquery.html#value" > value< / a > ( "quantity").toDouble() );
}
return TQVariant( TQString::null );
}
TQSqlRecord *InvoiceItemCursor::< a href = "tqsqlcursor.html#primeInsert" > primeInsert< / a > ()
{
< a href = "tqsqlrecord.html" > TQSqlRecord< / a > *buffer = < a href = "tqsqlcursor.html#editBuffer" > editBuffer< / a > ();
< a href = "tqsqlquery.html" > TQSqlQuery< / a > query( "SELECT NEXTVAL( 'invoiceitem_seq' )" );
if ( query.< a href = "tqsqlquery.html#next" > next< / a > () )
buffer-> < a href = "tqsqlrecord.html#setValue" > setValue< / a > ( "id", query.< a href = "tqsqlquery.html#value" > value< / a > ( 0 ) );
buffer-> < a href = "tqsqlrecord.html#setValue" > setValue< / a > ( "paiddate", TQDate::currentDate() );
buffer-> < a href = "tqsqlrecord.html#setValue" > setValue< / a > ( "quantity", 1 );
return buffer;
}
int main( int argc, char *argv[] )
{
< a href = "tqapplication.html" > TQApplication< / a > app( argc, argv );
if ( createConnections() ) {
InvoiceItemCursor invoiceItemCursor;
< a href = "tqdatatable.html" > TQDataTable< / a > *invoiceItemTable = new < a href = "tqdatatable.html" > TQDataTable< / a > ( & invoiceItemCursor );
app.< a href = "tqapplication.html#setMainWidget" > setMainWidget< / a > ( invoiceItemTable );
invoiceItemTable-> < a href = "tqdatatable.html#addColumn" > addColumn< / a > ( "productname", "Product" );
invoiceItemTable-> < a href = "tqdatatable.html#addColumn" > addColumn< / a > ( "price", "Price" );
invoiceItemTable-> < a href = "tqdatatable.html#addColumn" > addColumn< / a > ( "quantity", "Quantity" );
invoiceItemTable-> < a href = "tqdatatable.html#addColumn" > addColumn< / a > ( "cost", "Cost" );
invoiceItemTable-> < a href = "tqdatatable.html#addColumn" > addColumn< / a > ( "paiddate", "Paid" );
invoiceItemTable-> < a href = "tqdatatable.html#refresh" > refresh< / a > ();
invoiceItemTable-> < a href = "tqwidget.html#show" > show< / a > ();
return app.< a href = "tqapplication.html#exec" > exec< / a > ();
}
return 1;
}
< / pre > <!-- eof -->
< p > < address > < hr > < div align = center >
< table width = 100% cellspacing = 0 border = 0 > < tr >
< td > Copyright © 2007
< a href = "troll.html" > Trolltech< / a > < td align = center > < a href = "trademarks.html" > Trademarks< / a >
< td align = right > < div align = right > TQt 3.3.8< / div >
< / table > < / div > < / address > < / body >
< / html >
