Write xls  file  to  database
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
itru · 2014-10-29 17:59

Thanks for  your  effort   for  improving   FPSpreadsheet

 exporting a database  is   fine.   However,   How is  it
possible    to    savetoblob (  write  xls  file   in  database blob 
field  and  import  from  database  as  well.

How can  we  do  that

Regards

----------------------------------------------------------------------
wp · 2014-10-29 19:34

You want to write an entire xls file into a blob file of a database?
Not very DB-active at the moment, but I'd guess: in the same way as
with any other binary data types. Maybe something like this:

Code: [Select]// Write xls file to blob field
var
  stream: TStream;
  dataset: TDataset;
  field: TBlobField;
begin
  stream := TMemoryStream.Create;
  stream.LoadFromFile(xlsFile);
  stream.Position := 0;
  dataset.Insert;
  field.LoadFromStream(stream);
  dataset.Post;
  stream.Free;
end;

For reading from DB you just reverse the order of basic operations and
the "LoadFrom" by "SaveTo", i.e.
- create stream
- write field to stream
- reset stream position
- save stream to file.

----------------------------------------------------------------------
taazz · 2014-10-29 20:20

Quote from: wp on October 29, 2014, 08:34:09 pmYou want to write an
entire xls file into a blob file of a database? Not very DB-active at
the moment, but I'd guess: in the same way as with any other binary
data types. Maybe something like this:

Code: [Select]// Write xls file to blob field
var
  stream: TStream;
  dataset: TDataset;
  field: TBlobField;
begin
  stream := TMemoryStream.Create;
  stream.LoadFromFile(xlsFile);
  stream.Position := 0;
  dataset.Insert;
  field.LoadFromStream(stream);
  dataset.Post;
  stream.Free;
end;

For reading from DB you just reverse the order of basic operations and
the "LoadFrom" by "SaveTo", i.e.
- create stream
- write field to stream
- reset stream position
- save stream to file.

Don't use a memory stream, there is no reason to load it in memory if
it can be read directly from file (Tfilestream), I would rather avoid
out of memory exceptions if I have a saying.

----------------------------------------------------------------------
itru · 2014-11-06 09:58

Hello,

speedy  , main form   comboex.pas  where can we  find  it .  it fails 
when  it  is compiled. (comboex.pas  is missing fault)

Regards

Compiler  last version  of  Lazarus Ide.

----------------------------------------------------------------------
wp · 2014-11-06 12:09

Sorry, this is a remainder from an experimental version. Please remove
the ComboboxEx from the uses clause, it is not needed.

----------------------------------------------------------------------
wp · 2014-11-06 23:04

This bug is fixed in the current svn revision 3705