Reading and writing Blob field via RemoteDB

[_Schweiz_AG_Swisscom]

Hello Support,
do you have any example for reading and writiing blob fields using RemoteDB.
The database is Oracle, we use UniDac as DB-connector.

Thank you for any support
Kind regards
Jean-Luc

[Romero_Parra_Alejandro]

I am a regular user

I used SQLServer and SQLite and for both database engines my technique is the same:

First I put a TXDataSet and set SQL property like:

Update Photos
Set Image = :Photo
Where ID = :ID

Then I call the TXDataSet as below

With ActualizaFoto do
Begin
   Close;
   ParamByName('ID').AsInteger := IDValue;
   ParamByName('Photo').LoadFromStream(ImagenEnviar, ftBlob);
   Execute;
End;

I hope this works for you too