Devart Forums

There are still errors using version 8.4.2 and 8.4.3 The error occurres when posting Blobs. Here is my code, it works fine in version 8.3.2.

Error is Access violation.

procedure TfrmSkanneDocument.SaveDocument(dokumenttype : string; Nummeret : integer);
var
ms : TMemorystream;
i : integer;
begin

ms:=TMemorystream.create;

tiffviserd.MIO.SaveTostreamtiff(ms,false);

try

screen.cursor:=crsqlwait;

dataene.Lagre.SQL.Clear;
dataene.lagre.sql.add('INSERT INTO dokumenter');
dataene.lagre.sql.add('(Nummer,Dokumenttype,Navn,Tilhorer,Dato,Bilde,Privat,Askpassord,Bildenummer,Skalikkeslettes)');
dataene.lagre.sql.add('VALUES(:pNummer,:pDokumenttype,:pNavn,:pTilhorer,:pDato,:pBilde,:pPrivat,:pAskpassord,:pBildenummer,:pSkalikkeslettes)');
dataene.lagre.ParamByName('pNummer').asinteger:=nummeret;
dataene.lagre.ParamByName('pDokumenttype').asstring:=dokumenttype;
dataene.lagre.ParamByName('pNavn').asstring:=txtbeskrivelse.Text;
dataene.lagre.ParamByName('pTilhorer').asstring:=bruker.Pologget;
dataene.lagre.ParamByName('pDato').asdatetime:=txtdato.date;
dataene.lagre.ParamByName('pBilde').setblobdata(ms.Memory,ms.size);
dataene.lagre.ParamByName('pPrivat').asboolean:=chkprivat.Checked;
dataene.lagre.ParamByName('pAskpassord').asboolean:=chkaskpassord.Checked;
dataene.lagre.ParamByName('pSkalikkeslettes').asboolean:=chkskalikkeslettes.Checked;
dataene.lagre.ParamByName('pBildenummer').asinteger:=tiffviserd.ImageCount-1;

dataene.lagre.Execute;

finally
ms.Free;
screen.Cursor:=crdefault;
end;

end;

Regards,
Ole

Hello,
Unfortunately, we couldn't reproduce the issue.
Please send us an example that uses UniDAC and demonstrates the incorrect behavior, along with DDL scripts for creating and populating the database objects. Please send them through the form on our website: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

dataene.lagre.ParamByName('pBilde').setblobdata(ms.Memory,ms.size);

try to make
LoadFrom Stream(ms,ftBLOB);

I use it at 8.3.2 but stil lscary to install 8.4 , so i'll wait for your responce ))

I can confirm that the problem exists.
My collegs test this with 8.4.3.
Now we still use 8.3.2.

Best regards
Frank

We haven't yet received any files from you. Could you please resend the sample project?