home *** CD-ROM | disk | FTP | other *** search
- object fmMain: TfmMain
- Left = 255
- Top = 198
- Width = 494
- Height = 275
- Caption = 'CommandDemo'
- Color = clBtnFace
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -11
- Font.Name = 'MS Sans Serif'
- Font.Style = []
- OldCreateOrder = False
- OnCreate = FormCreate
- PixelsPerInch = 96
- TextHeight = 13
- object ToolBar1: TToolBar
- Left = 0
- Top = 0
- Width = 486
- Height = 29
- ButtonHeight = 21
- ButtonWidth = 66
- Caption = 'ToolBar1'
- EdgeBorders = [ebRight, ebBottom]
- Flat = True
- ShowCaptions = True
- TabOrder = 0
- object btnUpdate: TToolButton
- Left = 0
- Top = 0
- Caption = 'Update Cost'
- ImageIndex = 0
- OnClick = btnUpdateClick
- end
- end
- object ListView: TListView
- Left = 0
- Top = 29
- Width = 486
- Height = 219
- Align = alClient
- Columns = <
- item
- Caption = 'PartNo'
- Width = 70
- end
- item
- AutoSize = True
- Caption = 'Description'
- end
- item
- Caption = 'Cost'
- Width = 70
- end>
- RowSelect = True
- SortType = stText
- TabOrder = 1
- ViewStyle = vsReport
- end
- object Conn: TConnection
- AutoConnect = True
- ConnectKind = ckRunningOrNew
- ConnectionString =
- 'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data ' +
- 'Source=db.mdb;Mode=Share Deny None;Extended Properties="";Jet OL' +
- 'EDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Data' +
- 'base Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Lock' +
- 'ing Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global ' +
- 'Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB' +
- ':Create System Database=False;Jet OLEDB:Encrypt Database=False;J' +
- 'et OLEDB:Don'#39't Copy Locale on Compact=False;Jet OLEDB:Compact Wi' +
- 'thout Replica Repair=False;Jet OLEDB:SFP=False'
- CommandTimeout = 30
- ConnectionTimeout = 15
- IsolationLevel = 4096
- Attributes = 0
- CursorLocation = 2
- Mode = 16
- Provider = 'Microsoft.Jet.OLEDB.4.0'
- ConnectOption = 0
- Active = False
- Left = 120
- Top = 80
- end
- object rst: TRecordset
- AutoConnect = False
- ConnectKind = ckRunningOrNew
- AbsolutePosition = -1
- CacheSize = 1
- CursorType = 0
- LockType = 1
- MaxRecords = 0
- AbsolutePage = -1
- PageSize = 10
- CursorLocation = 2
- MarshalOptions = 0
- Connection = Conn
- Source = 'parts'
- CommandType = 0
- Left = 200
- Top = 80
- end
- object Command: TCommand
- AutoConnect = False
- ConnectKind = ckRunningOrNew
- CommandText = 'UPDATE Parts SET Cost = Cost * UpdVal'
- CommandTimeout = 30
- Prepared = False
- CommandType = 1
- Connection = Conn
- Left = 160
- Top = 80
- end
- end
-