Hi all:
I'm developing an document management system. I want to save documents into a table in MS SQLServer DataBase. I'm using SQLDB.My problem is that I can save files properly, but not read it when the file is lager than 16,777,216 bytes.The data is correctly saved, If I use Zeos, I can read it and save it as a file withoit size restriction.
I tryed several methods:
Directly:
TBLOBField(fieldByName('Contenido')).LoadFromFile(fileNames[0]);
With this method, if I try to do inmediatly after save, it works:
TBLOBField(fieldByName('Contenido')).LoadFromFile(fileNames[0]);
Post;
SQLQuery1.ApplyUpdates;
datos.trBD.CommitRetaining;
// Read. It works
TBLOBField(fieldByName('Contenido')).saveToFile(fileNames[0]+'-Regrabado'+extractFileExt(fileNames[0]) );
With an auxiliar stream:
st:= TFileStream.create(sd.FileName, fmCreate);
TBLOBField(fieldByName('Contenido')).SaveToStream(st);
st.position:=0; st.Free;
With CreateBlobStream:
bs:=CreateBlobStream(fieldByName('Contenido'),bmread);
bs.position:=0;
Any suggestion?
Thanks.