sqlIfStmt.h

Go to the documentation of this file.

/*******************************************************************************
** Copyright (c) 1992-2010 VT MAK
** All rights reserved.
*******************************************************************************/


#pragma once

#ifdef _WIN32
#include <windows.h>
#include <sqltypes.h>
#else
#include <sqltypes.h>
#endif

#include "sqlIfError.h"
#include "databaseCommandProcessor.h"

class DtString;
class DtSqlConnection;

// Once a connection is established with a database, communication with the
// database is typically done using SQL commands.  An SQL statement object is
// needed to execute the commands.  This class creates a such a statement 
// object. Only once such object is needed - once created, it can used to send
// any number of SQL commands. The constructor must be passed a connection 
// handle that is currently connected to a database.  Although this class can be
// set up and used directly, its usually easier to set up a  
// object. DtSqlIfDatabase automatically allocates a DtSqlIfStatement when it
// connects to a database (using its dbConnect() method).
class DT_DLL_VLDB DtSqlStatement : public DtDatabaseCommandProcessor
{
public:
   // Constructor
   explicit DtSqlStatement( DtSqlConnection& connection);

   // Destructor
   virtual ~DtSqlStatement();

   // execute an SQL command
   virtual bool processCommand( const DtString& cmdStr );

   // Get the maximum allowed column width
   virtual unsigned int getMaximumColumnWidgth();

   // Accessors / Mutators

   // returns a handle to the statement object allocated by this class
   SQLHSTMT handle();

protected:
   SQLHSTMT myHandle;
   DtSqlIfErrorHandler myErrorHandler;
};