Re: Problem with insert statement in Delphi

[Andrey Sokolov]

I've similar problem with inserting file into
BLOB. The file size is about 500k so i use
mediumblob filed type.
Inserting:

Qry.SQL.Text:='INSERT INTO tbl_brcfile VALUES(:BrdKey, :Brc)';

Qry.Parameters.ParamByName('BrdKey').Value:=BrdKey;
Qry.Parameters.ParamByName('Brc').LoadFromFile(BrcFileName, ftBlob);
try
Qry.ExecSQL;

Qry has type TADOQuery.
The at the last string (ExecSQL) apears the
exception "Connection was lost". The program
really looses the coonection but then reconnects
automatically. No data is inserted into the table.
What shall i do?:( Help!