Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread ParamByname and blob fields
Wed, Apr 25 2007 10:15 PMPermanent Link

Alfred Ghazzi
Hi

I know there is an issue with the remote parameterized statements. I was able to use workaround code to fix all but this one.

Query1.SQL.Text := 'UPDATE Table SET Data = :Data WHERE ID = 1';
vStream := TMemoryStream.Create;
try
  MyObject.SaveData(vStream);
  vStream.Seek(0, soFromBeginning);
  ////// Is there a workaround code for the following line /////
  Query1.ParamByName('Data').LoadFromStream(vStream, ftBlob);
finally
vStream.Free;
end;
Query1.ExecSQL;

Thank you in advance

Alfred
Thu, Apr 26 2007 12:59 AMPermanent Link

Alfred Ghazzi
Hi

I found a solution by using EDBTable

Thanks to all

Alfred
Image