大家看看我这断代吗错在那里了
总提示我Insert Into 语法错误
procedure TForm1.Button1Click(Sender: TObject);
var
MyJPEG: TJPEGImage;
MS: TMemoryStream;
Image: TImage;
testStream:TMemoryStream;
begin
Image := TImage.Create(nil);
image.Picture.LoadFromFile('G:/班级活动/纪念册个人照片/'+Trim(Edit12.Text)+'.jpg');
MyJPEG := TJPEGImage.Create;
try
with MyJPEG do
begin
Assign(Image.Picture.Graphic);
MS := TMemoryStream.create;
SaveToStream(MS);
MS.Position := 0;
with dmform.qry1 do
begin
close;
sql.Clear;
sql.add('insert into Person (No,Name,HomeTown,BirthDay,Office,City,Mobile,HomePhone,OPhone,QQ,MSN,Email,Pic)');
sql.add(' values
![Smile (: (:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
No,:Name,:HomeTown,:BirthDay,:Office,:City,:Mobile,:HomePhone,:OPhone,:QQ,:MSN,:EMail,
![Stick Out Tongue :P :P](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
ic)');
Parameters.ParamValues['No']:=Edit11.Text;
Parameters.ParamValues['Name']:=Edit12.Text;
Parameters.ParamValues['HomeTown']:=Edit10.Text;
Parameters.ParamValues['BirthDay']:=Edit9.Text;
Parameters.ParamValues['Office']:=Edit1.Text;
Parameters.ParamValues['City']:=Edit2.Text;
Parameters.ParamValues['Mobile']:=Edit8.Text;
Parameters.ParamValues['HomePhone']:=Edit4.Text;
Parameters.ParamValues['OPhone']:=Edit5.Text;
Parameters.ParamValues['QQ']:=Edit6.Text;
Parameters.ParamValues['MSN']:=Edit7.Text;
Parameters.ParamValues['EMail']:=Edit3.Text;
Parameters.ParamByName('Pic').LoadFromStream(MS,ftblob);
Execsql;
end;
image.Picture.CleanupInstance;
end;
finally
MyJPEG.Free;
Image.Free;
Image := nil;
end;
end;