MySQL Forums
Forum List  »  Delphi

Re: Problem with insert statement in Delphi
Posted by: Andrey Sokolov
Date: June 12, 2006 03:04AM

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!

Options: ReplyQuote


Subject
Written By
Posted
Re: Problem with insert statement in Delphi
June 12, 2006 03:04AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.