Re: Pass file to Blob param Stored Procedure

[sher khan]

Solveeeedddddddd

Instead of using TSQLStoredProc, i used TmySQLQuery.

Delphi code
===========

mySQLQuery1.SQL.Add('call testBlob(:ID,:photo)');
mySQLQuery1.ParamByName('ID').Value:='00000'+ TimeToStr(Now());
mySQLQuery1.ParamByName('photo').LoadFromFile(ExtractFilePath(ParamStr(0))+
('NewImage.jpg'),ftBlob);
mySQLQuery1.ExecSQL;

I still don;t know why TSQLStoredProc not working...I might work on that for a while and move on with or without solving it coz mySQLQuery1 Worksssss......