🚀 go-pugleaf

I am trying to write a Blob to an ADO in C++ Builder 5. The BlobStream
is operating fine and I have verified that my data is written to it.
But following a Post command, which should send it to the ADO, the
BlobStream is not entered into the database. The field where it should
be is empty. Here is an extract of one of the many methods I have
tried:

TADOBlobStream *lStream = NULL;
lStream = (TADOBlobStream*)
pTrendTable->CreateBlobStream(pTrendTable->FieldByName(MPWM_PARAM_TREND),bmReadWrite);
int lNo = 0;
while (fgets(lTitle.c_str(), lTitle.Length(), lFileStream)!=NULL)
{
   // Store param value as short int in blob-stream
   short int num = (short int) lList->Strings[np].ToInt();
   lStream->Write(&num, sizeof(short int));
   lNo++;
}
pTrendTable->FieldByName(MPW_SYSTEM_ID)->AsString = lSystem_ID;
pTrendTable->FieldByName(MPW_STUDY_ID)->AsString = lStudy_ID;
pTrendTable->FieldByName(MPW_PATIENT_NO)->AsInteger = lPatient_No;
pTrendTable->FieldByName(MPWM_SESSION_ID)->AsInteger = lSession_ID;
pTrendTable->FieldByName(MPWM_PARAM_ID)->AsInteger = np + 1;
pTrendTable->FieldByName(MPWM_PARAM_NAME)->AsString =
lColumnNames->Strings[np];
pTrendTable->Post();

   Values are posted to all the above fields except the BlobField. I
am using Microsoft Jet 4.0 OLE DB Provider and Microsoft Access.

If anyone can help, it would be greatly appreciated.

Cheers,
Paul