pfibdsgnviewsqls.dfm

FIBPlus is a component suite intended for work with InterBase. It is direct, fast and flexible Inter

      00000000FF000000000000000000FFFFFF00FFFFFF0000000000000000000000
      0000000000000000000000000000000000000000000000000000848484000000
      0000FFFFFF00000000000000000000000000FFFFFF00FFFFFF00FFFFFF000000
      00008484840000000000000000000000000000000000FFFFFF00000000000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00000000000000
      000000000000000000000000000000000000000000000000000084848400FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF0084848400FFFFFF00FFFF
      FF00000000008484840000000000000000000000000000000000000000000000
      FF00FFFFFF000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000848484000000
      0000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF000000
      00008484840000000000000000000000000000000000FFFFFF00FFFFFF000000
      0000840000008400000084000000840000008400000084000000000000000000
      000000000000000000000000000000000000000000000000000084848400FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF0084848400848484000000
      00000000000000000000848484000000000000000000000000000000FF00FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000848484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00008484840000000000000000000000000000000000FFFFFF00000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000848484008484
      8400848484008484840084848400848484008484840084848400000000000000
      000000000000000000000000000000000000000000000000FF00FFFFFF000000
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000848484008484
      8400848484008484840084848400848484008484840084848400848484008484
      84008484840000000000000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000FFFFFF00000084000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000084000000840000008400
      0000840000008400000084000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000FFFF0000FFFF0000FFFF00000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000FFFFFF00FFFFFF000000000000000000FFFFFF0000FFFF00FFFF
      FF0000FFFF0000000000FFFF0000FFFF00000000000000000000008484000084
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000084840000000000000000000000000000000000000000000000
      00000000000000000000000000000000000084000000FFFFFF00000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000FFFFFF000000000000000000000000000000000000000000000000000000
      0000FFFFFF000000000000000000000000000000000000000000000000000000
      000000000000FFFFFF000000000000FFFF00FFFFFF0000FFFF000000000000FF
      FF00FFFFFF0000FFFF0000000000FFFF00000000000000000000008484000084
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000084840000000000000000000000000000000000000000000000
      0000000000000000000000000000840000008400000084000000FFFFFF000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000FFFFFF000000000000000000000000000000000000000000000000000000
      0000FFFFFF000000000000000000000000000000000000000000000000000000
      000000000000FFFFFF00FFFFFF0000000000000000000000000000FFFF00FFFF
      FF0000FFFF00FFFFFF0000FFFF00000000000000000000000000008484000084
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000084840000000000000000000000000000000000000000000000
      0000000000000000000084000000840000008400000084000000FFFFFF000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000FFFFFF000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000FFFFFF00FFFFFF00FFFFFF000000000000FFFF00FFFFFF0000FF
      FF00FFFFFF0000FFFF00FFFFFF00000000000000000000000000008484000084
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000084840000000000000000000000000000000000000000000000
      000000000000840000008400000084000000FFFFFF008400000084000000FFFF
      FF00000000000000000000000000000000008400000084000000840000000000
      000000000000FFFFFF0000000000000000000000000000000000FFFFFF000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000FFFF00FFFFFF0000000000FFFF
      FF0000FFFF00FFFFFF0000FFFF00000000000000000000000000008484000084
      8400008484000084840000848400008484000084840000848400008484000084
      84000084840000848400000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00840000008400000084000000FFFFFF000000000000000000840000008400
      0000FFFFFF0000000000000000000000000084000000FFFFFF00FFFFFF00FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000000000000FFFF
      FF0000FFFF00FFFFFF0000FFFF0000000000FFFFFF0000000000FFFFFF0000FF
      FF000000000000FFFF00FFFFFF00000000000000000000000000008484000084
      8400000000000000000000000000000000000000000000000000000000000000
      00000084840000848400000000000000000000000000FFFFFF00848484008484
      84008484840084000000FFFFFF00FFFFFF000000000000000000000000008400
      0000FFFFFF0000000000000000000000000084000000FFFFFF00848484008484
      840000000000FFFFFF0000000000000000000000000000000000FFFFFF000000
      000000000000000000000000000000000000FFFF000000000000FFFFFF0000FF
      FF00000000000000000000000000000000000000000000000000000000000000
      000000FFFF00FFFFFF0000000000000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000848400000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF000000000000000000000000000000
      000084000000FFFFFF00000000000000000084000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000FFFF00000000000000FFFF00FFFF
      FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF000000
      0000FFFFFF0000000000FFFFFF00000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000848400000000000000000000000000FFFFFF00848484008484
      8400848484008484840084848400FFFFFF000000000000000000000000000000
      00000000000084000000FFFFFF000000000084000000FFFFFF00848484008484
      8400FFFFFF0000000000FFFFFF0000000000848484008484840000000000FFFF
      FF0000000000000000000000000000000000FFFF000000000000FFFFFF0000FF
      FF00FFFFFF0000FFFF0000000000000000000000000000000000000000000000
      000000000000FFFFFF00FFFFFF00000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000848400000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF000000000000000000000000000000
      0000000000000000000084000000FFFFFF0084000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00000000000000000000000000FFFFFF00FFFFFF00000000000000
      000000000000000000000000000000000000FFFF00000000000000FFFF00FFFF
      FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF000000
      0000FFFFFF00FFFFFF00FFFFFF00000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000848400000000000000000000000000FFFFFF00848484008484
      8400000000000000000000000000FFFFFF000000000000000000000000000000
      00000000000000000000000000008400000084000000FFFFFF00848484008484
      8400FFFFFF008484840084848400FFFFFF008484840084848400FFFFFF008400
      000000000000000000000000000000000000FFFF000000000000FFFFFF0000FF
      FF00FFFFFF0000FFFF000000000000000000000000000000000000000000FFFF
      FF00000000000000000000000000000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000084000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF008400
      000000000000000000000000000000000000FFFF00000000000000000000FFFF
      FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF0000000000FFFFFF00FFFF
      FF0000000000FFFFFF00FFFFFF00000000000000000000000000008484000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000FFFFFF00848484008484
      8400000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000008400000084000000840000008400
      0000840000008400000084000000840000008400000084000000840000008400
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF0000000000FFFFFF0000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000FFFFFF00FFFFFF00FFFF
      FF00FFFFFF000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000008400000000000000840000008400
      0000000000008400000084000000000000008400000084000000000000008400
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFF
      FF00000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000008400000084000000840000008400
      0000840000008400000084000000840000008400000084000000840000008400
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000424D3E000000000000003E000000
      2800000040000000300000000100010000000000800100000000000000000000
      000000000000000000000000FFFFFF00FB77000000000000F9B6000000000000
      80D500000000000089E30000000000009A000000000000009FE3000000000000
      805500000000000087B6000000000000E357000000000000055F000000000000
      201F000000000000001F000000000000201F00000000000000FF000000000000
      00FF00000000000000FF000000000000FFFFC012FFFFFFFFF007C000FFFFFFFF
      C007E0008003FFFBC007F0008003FFF1C007FC008003FFE0C007F8818003FFF1
      C007F0008003E011C007F0438003E551C007F0078003E281C007F0078003055F
      C027E00F8003201FC003C03F8003001FC01183FF8003201FC03907FF800300FF
      FFFD0FFF800300FFFFFF9FFFFFFF00FFFFFFFFFFFFFFF000C001FFFFE1E1F000
      8031FF3FE1E1F0008031FE1FE081F0008031FC1FE001F0008001000F0081E000
      800100470083000080010067000300008FF10073000700008FF1007900070000
      8FF1007C000700008FF10E7E000F00008FF1007F000F00008FF50AFF000F2001
      800101FF492FF003FFFF03FF000FF00700000000000000000000000000000000
      000000000000}
  end
  object PopupMenu3: TPopupMenu
    Left = 181
    Top = 238
    object miSaveallSQLs1: TMenuItem
      Caption = 'Save all SQLs'
      OnClick = miSaveallSQLs1Click
    end
    object SaveonlySelectSQL1: TMenuItem
      Caption = 'Save only SelectSQL'
      OnClick = miSaveallSQLs1Click
    end
  end
  object qryBuf: TpFIBQuery
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    GoToFirstRecordOnExecute = False
    Left = 357
    Top = 230
  end
  object qryObjects: TpFIBQuery
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    GoToFirstRecordOnExecute = False
    SQL.Strings = (
      'Select'
      '    ID,PROPERTY_VALUE'
      'from fib$objects'
      'where'
      '        PROJECT_ID     =:PID'
      '    and UNIT_NAME      =:UN'
      '    and COMPONENT_NAME =:CN'
      '    and PROPERTY       =:PN')
    Left = 405
    Top = 230
  end
  object qryInsObj: TpFIBQuery
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    GoToFirstRecordOnExecute = False
    SQL.Strings = (
      'Insert    into  fib$objects'
      '(     ID,'
      '      PROJECT_ID  ,'
      '      UNIT_NAME    ,'
      '      COMPONENT_NAME ,'
      '      PROPERTY ,'
      '      PROPERTY_VALUE '
      ')'
      'values'
      '        (:ID,:PID,:UN,:CN,:PN,:PV)')
    Left = 405
    Top = 278
  end
  object qryUpdObj: TpFIBQuery
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    GoToFirstRecordOnExecute = False
    SQL.Strings = (
      'UPDATE fib$objects'
      'SET PROPERTY_VALUE =:PV'
      'WHERE ID=:ID')
    Left = 357
    Top = 278
  end
  object qryDescr: TpFIBDataSet
    UpdateSQL.Strings = (
      'update RDB$RELATIONS set RDB$DESCRIPTION = :RDB$DESCRIPTION'
      'where RDB$RELATION_NAME=:OBJNAME')
    SelectSQL.Strings = (
      'select RDB$RELATION_NAME OBJNAME,'
      'RDB$DESCRIPTION from RDB$RELATIONS '
      'where RDB$RELATION_NAME = :OBJNAME')
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    DefaultFormats.DateTimeDisplayFormat = 'dd.mm.yyyy'
    Left = 309
    Top = 222
    poSetRequiredFields = True
    poSetReadOnlyFields = True
    poAskRecordCount = True
    dcForceMasterRefresh = True
    dcForceOpen = True
  end
  object qryAllDescr: TpFIBDataSet
    UpdateSQL.Strings = (
      'update RDB$RELATIONS set RDB$DESCRIPTION = :RDB$DESCRIPTION'
      'where RDB$RELATION_NAME=:OBJNAME')
    SelectSQL.Strings = (
      'select RDB$RELATION_NAME OBJNAME,'
      'RDB$DESCRIPTION from RDB$RELATIONS ')
    Transaction = pFIBTransaction1
    Database = pFIBDatabase1
    DefaultFormats.DateTimeDisplayFormat = 'dd.mm.yyyy'
    Left = 301
    Top = 278
    poSetRequiredFields = True
    poSetReadOnlyFields = True
    poAskRecordCount = True
    dcForceMasterRefresh = True
    dcForceOpen = True
  end
end