-
Notifications
You must be signed in to change notification settings - Fork 0
/
Unit6.dfm
176 lines (176 loc) · 3.51 KB
/
Unit6.dfm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
object Form6: TForm6
Left = 760
Top = 457
Caption = #220'r'#252'n Ekle'
ClientHeight = 251
ClientWidth = 658
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'Tahoma'
Font.Style = []
OldCreateOrder = False
Position = poDesigned
PixelsPerInch = 96
TextHeight = 13
object Label1: TLabel
Left = 99
Top = 35
Width = 54
Height = 13
Caption = #220'r'#252'n Kodu:'
end
object Label2: TLabel
Left = 99
Top = 75
Width = 45
Height = 13
Caption = #220'r'#252'n Ad'#305':'
end
object Label3: TLabel
Left = 98
Top = 112
Width = 61
Height = 13
Caption = #220'r'#252'n Miktar'#305':'
end
object Label4: TLabel
Left = 400
Top = 184
Width = 6
Height = 13
Caption = '0'
end
object Edit1: TEdit
Left = 160
Top = 32
Width = 121
Height = 21
TabOrder = 0
end
object Edit2: TEdit
Left = 160
Top = 72
Width = 121
Height = 21
TabOrder = 1
OnChange = Edit2Change
end
object Button1: TButton
Left = 184
Top = 152
Width = 75
Height = 25
Caption = 'Urun ekle'
TabOrder = 2
OnClick = Button1Click
end
object Edit3: TEdit
Left = 160
Top = 109
Width = 121
Height = 21
TabOrder = 3
end
object DBGrid1: TDBGrid
Left = 304
Top = 24
Width = 320
Height = 120
DataSource = DataSource1
TabOrder = 4
TitleFont.Charset = DEFAULT_CHARSET
TitleFont.Color = clWindowText
TitleFont.Height = -11
TitleFont.Name = 'Tahoma'
TitleFont.Style = []
Columns = <
item
Expanded = False
FieldName = 'urun_kodu'
Visible = True
end
item
Expanded = False
FieldName = 'urun_adi'
Width = 150
Visible = True
end
item
Expanded = False
FieldName = 'urun_miktari'
Visible = True
end>
end
object ADOQuery1: TADOQuery
Connection = Form1.ADOConnection1
Parameters = <
item
Name = 'x'
Attributes = [paNullable]
DataType = ftWideString
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end
item
Name = 'y'
Attributes = [paNullable]
DataType = ftWideString
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end
item
Name = 'z'
Attributes = [paNullable]
DataType = ftWideString
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end>
SQL.Strings = (
'insert into urunler values (:x,:y,:z)')
Left = 48
Top = 96
end
object ADOQuery2: TADOQuery
Connection = Form1.ADOConnection1
CursorType = ctStatic
Parameters = <
item
Name = 'x'#39'%'#39
Attributes = [paNullable]
DataType = ftWideString
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end>
SQL.Strings = (
'select *'
'from urunler'
'where urun_adi like '#39'%'#39' +:x'#39'%'#39)
Left = 512
Top = 176
object ADOQuery2urun_kodu: TIntegerField
FieldName = 'urun_kodu'
end
object ADOQuery2urun_adi: TWideStringField
FieldName = 'urun_adi'
Size = 255
end
object ADOQuery2urun_miktari: TIntegerField
FieldName = 'urun_miktari'
end
end
object DataSource1: TDataSource
DataSet = ADOQuery2
Left = 576
Top = 176
end
end