Reading and writing Blob field via RemoteDB

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

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
   ParamByName('ID').AsInteger := IDValue;
   ParamByName('Photo').LoadFromStream(ImagenEnviar, ftBlob);

I hope this works for you too

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.