unitgoods.dfm

一个操作sql server的实例

object FormGoods: TFormGoods
  Left = 237
  Top = 119
  Width = 696
  Height = 480
  Caption = 'FormGoods'
  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 DataSource1: TDataSource
    DataSet = Query1
    Left = 72
    Top = 8
  end
  object Query1: TQuery
    AfterPost = Query1AfterPost
    DatabaseName = 'TestDatabase'
    RequestLive = True
    SQL.Strings = (
      'Select * from Goods')
    UpdateObject = UpdateSQL1
    Left = 32
    Top = 8
  end
  object UpdateSQL1: TUpdateSQL
    ModifySQL.Strings = (
      'update Goods'
      'set'
      '  iNo = :iNo,'
      '  sName = :sName,'
      '  sEName = :sEName,'
      '  iUnit = :iUnit,'
      '  fPrice = :fPrice'
      'where'
      '  iNo = :OLD_iNo')
    InsertSQL.Strings = (
      'insert into Goods'
      '  (iNo, sName, sEName, iUnit, fPrice)'
      'values'
      '  (:iNo, :sName, :sEName, :iUnit, :fPrice)')
    DeleteSQL.Strings = (
      'delete from Goods'
      'where'
      '  iNo = :OLD_iNo')
    Left = 120
    Top = 120
  end
end