unitstore.dfm

包含众多详细的delphi对数据库的访问代码

object FormStore: TFormStore
  Left = 237
  Top = 119
  Width = 696
  Height = 480
  Caption = 'FormStore'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poDefault
  Visible = True
  WindowState = wsMaximized
  OnActivate = FormActivate
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 0
    Top = 0
    Width = 688
    Height = 453
    Align = alClient
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Query1: TQuery
    AfterPost = Query1AfterPost
    DatabaseName = 'TestDatabase'
    RequestLive = True
    SQL.Strings = (
      'Select * from Store')
    UpdateObject = UpdateSQL1
    Left = 32
    Top = 8
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 72
    Top = 8
  end
  object UpdateSQL1: TUpdateSQL
    ModifySQL.Strings = (
      'update Store'
      'set'
      '  iNo = :iNo,'
      '  sName = :sName,'
      '  sEName = :sEName'
      'where'
      '  iNo = :OLD_iNo')
    InsertSQL.Strings = (
      'insert into Store'
      '  (iNo, sName, sEName)'
      'values'
      '  (:iNo, :sName, :sEName)')
    DeleteSQL.Strings = (
      'delete from Store'
      'where'
      '  iNo = :OLD_iNo')
    Left = 200
    Top = 208
  end
end