main.dfm

ODAC+SDAC源代码

object fmMain: TfmMain
  Left = 201
  Top = 136
  Width = 674
  Height = 440
  VertScrollBar.Range = 223
  ActiveControl = DBGrid1
  AutoScroll = False
  Caption = 'Oracle Data Access Demo - using PL/SQL cursors'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = 11
  Font.Name = 'MS Sans Serif'
  Font.Pitch = fpVariable
  Font.Style = []
  OldCreateOrder = True
  Position = poScreenCenter
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 0
    Top = 27
    Width = 666
    Height = 196
    Align = alTop
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object ToolBar: TPanel
    Left = 0
    Top = 0
    Width = 666
    Height = 27
    Align = alTop
    TabOrder = 1
    object btOpen: TButton
      Left = 0
      Top = 2
      Width = 75
      Height = 22
      Caption = 'Open'
      TabOrder = 0
      OnClick = btOpenClick
    end
    object btClose: TButton
      Left = 75
      Top = 2
      Width = 75
      Height = 22
      Caption = 'Close'
      TabOrder = 2
      OnClick = btCloseClick
    end
    object DBNavigator: TDBNavigator
      Left = 150
      Top = 2
      Width = 240
      Height = 22
      DataSource = DataSource1
      TabOrder = 1
    end
    object cbDebug: TCheckBox
      Left = 406
      Top = 2
      Width = 75
      Height = 22
      Caption = '  Debug'
      TabOrder = 3
      OnClick = cbDebugClick
    end
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 223
    Width = 666
    Height = 190
    Align = alClient
    DataSource = DataSource2
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
  end
  object OraSession: TOraSession
    Username = 'Scott'
    Password = 'tiger'
    ConnectDialog = ConnectDialog
    Left = 344
    Top = 32
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 408
    Top = 64
  end
  object ConnectDialog: TConnectDialog
    SavePassword = True
    Caption = 'Connect'
    UsernameLabel = 'Username'
    PasswordLabel = 'Password'
    ServerLabel = 'Server'
    ConnectButton = 'Connect'
    CancelButton = 'Cancel'
    LabelSet = lsCustom
    Left = 376
    Top = 32
  end
  object Query1: TOraQuery
    SQLInsert.Strings = (
      'INSERT INTO Scott.Dept'
      '  (DEPTNO, DNAME, LOC)'
      'VALUES'
      '  (:DEPTNO, :DNAME, :LOC)')
    SQLDelete.Strings = (
      'DELETE FROM Scott.Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO')
    SQLUpdate.Strings = (
      'UPDATE Scott.Dept'
      'SET'
      '  DEPTNO = :DEPTNO,'
      '  DNAME = :DNAME,'
      '  LOC = :LOC'
      'WHERE'
      '  DEPTNO = :OLD_DEPTNO')
    SQLLock.Strings = (
      'SELECT * FROM Scott.Dept'
      'WHERE'
      '  DEPTNO = :DEPTNO'
      'FOR UPDATE NOWAIT')
    Session = OraSession
    SQL.Strings = (
      'begin'
      '  OPEN :Cur1 FOR'
      '    SELECT D.*, D.RowId'
      '    FROM Scott.Dept D'
      '    ORDER BY DeptNo;'
      '  OPEN :Cur2 FOR'
      '    SELECT D.*, D.RowId'
      '    FROM Scott.Emp D'
      '    ORDER BY EmpNo;'
      'end;')
    Debug = True
    Left = 408
    Top = 32
    ParamData = <
      item
        DataType = ftCursor
        Name = 'Cur1'
        ParamType = ptOutput
      end
      item
        DataType = ftCursor
        Name = 'Cur2'
        ParamType = ptOutput
      end>
  end
  object DataSource2: TDataSource
    DataSet = Query2
    Left = 448
    Top = 64
  end
  object Query2: TSmartQuery
    UpdatingTable = 'Scott.Emp'
    Session = OraSession
    SQL.Strings = (
      'SELECT T.*, T.RowId FROM Scott.Emp T')
    Debug = True
    LockMode = lmNone
    Left = 448
    Top = 32
  end
end