dmunit.cpp

Direct Oracle Access 非常好的Oracle数据库直接访问组件包 支持个版本的Delphi及C++ Builder 有源码

// Direct Oracle Access - PictureDemo
// Allround Automations
// [e-mail]
// http://www.allroundautomations.nl
//
// This application demonstrates:
// - The use of a BLOB field in a dataset
// - The use of Data Definition Language (creating & dropping a table)
// - The use of a Data Module for the DOA components
//---------------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop

#include "DMUnit.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "Oracle"
#pragma link "OracleData"
#pragma resource "*.dfm"
TDM *DM;
//---------------------------------------------------------------------------
__fastcall TDM::TDM(TComponent* Owner)
    : TDataModule(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TDM::DataModule1Create(TObject *Sender)
{
  // Show the logon dialog
  OracleLogon->Execute();
  // If not connected then exit
  if (OracleSession->Connected)
  {
    try
    {
      // Test if the demotable exists
      CheckTableQuery->Execute();
      if (CheckTableQuery->Eof)
      {
        // If not, ask to create it
        if (MessageDlg("Create demo table DOA_PICTUREDEMO ?", mtConfirmation,
                       TMsgDlgButtons() << mbYes << mbNo, 0) == mrYes)
          CreateTableQuery->Execute();
        else
          OracleSession->Connected = false;
      }
    }
    catch (EOracleError &E)
    {
      ShowMessage(E.Message);
    }
  }
  // If everything is OK activate the dataset
  if (OracleSession->Connected)
    OracleDataSet->Active = true;
  else
    Application->Terminate();
}
//---------------------------------------------------------------------------