procedure
TMyThread
.
AddToDbCb(AFileName:
String
; ASize:
Integer
);
begin
SqlConnection1
.
Open;
try
SqlQuery1
.
SQL
.
Text :=
'INSERT INTO test1 (id, name, reviews, size, attribute) VALUES (:id, :name, :reviews, :size, :attribute)'
;
SqlQuery1
.
ParamByName(
'id'
).AsInteger :=
1
;
SqlQuery1
.
ParamByName(
'name'
).AsString := AFileName;
SqlQuery1
.
ParamByName(
'reviews'
).AsInteger := random(
5
);
SqlQuery1
.
ParamByName(
'size'
).AsInteger := ASize;
SqlQuery1
.
ParamByName(
'attribute'
).AsString :=
'gggggg'
;
SQLQuery1
.
ExecSQL;
Memo1
.
Lines
.
Add(
'Запись_добавлена='
+Afilename+inttostr(ASize));
finally
SqlConnection1
.
Close;
end
;
end
;