🚀 go-pugleaf

Hi,

I have tested your solution #4, but it does not support BLOBS !?
Message "BLOB NOT FOUND"

Also the database keeps growing with every delete / Insert

Any suggestions?

Dietrich




"CleverComponents Team" <info@clevercomponents.com> schrieb im Newsbeitrag
news:3df14ea9$1@newsgroups.borland.com...
>
> Hello Dietrich,
>
> What about solution #4 -  use TIBSQL and BatchInput, BatchOutput,
> InputRawFile,OutputRawFile features?
>
> The fastest and the easyest way so far.
>
> Steps:
> 1) Create OutputRawFile with TIBSQL.BatchOutput
> 2) zip it and send (you can use ZLib)
> 3) unzip it on a client a client side into InputRawFile
> 4) Start transaction, empty your table, load data from InputRawFile using
> TIBSQL.BatchInput and Commit
>
> Whole code size will be about 100 lines max.
>
> Best regards,
>
> CleverComponents Team
> www.CleverComponents.com
> info@CleverComponents.com
>
> "D.v.Witzleben" <info@witzleben-edv.de> wrote in message
> news:3df0d44d@newsgroups.borland.com...
> > Hi
> >
> > I build the following application:
> >
> > CENTRAL-APP: They are able to Insert/Modify (not delete) Item-Data
(table
> > ITEM). Then this data has to be send to the shops via 64K Modem.
> >
> > SHOPS-APP: They receive ITEM-Table with new items, sell products into
the
> > SOLD-Table, and are only able to read the ITEM-table.
> >
> > I figured following solutions:
> >
> > 1: Replication on record-basis for table ITEM through delphi / IBX,
works
> > fine.
> >    PROBLEM: It takes 3-5 hours a day. Also the destination DB grows
> > extremely in size.
> >
> > 2: Export table ITEM with Delphi/BDE/Batchmove into ITEM.DBF, import
into
> > SHOP-APP the same way.
> >   PROBLEM: The destination DB grows extremely in size, when you close
it,
> it
> > seems to hang, after a while it does close.
> >
> > 3: "Create table itemexternal external file ITEMEXTERNAL.TXT" in
> Interbase,
> > insert data with insert into itemexternal select * from item. In the
> > SHOPS-APP there is no internal ITEM-table, I use the external
> > ITEMEXTERNAL-table directly for read-purposes. Works very fine.
> >   PROBLEM: No BLOB-DATA! Also I can't copy the file while someone is
> working
> > on the DB, since it's locked.
> >
> > Question: Any idea on problem 1-3?
> >
> > Thanks,
> >
> > Dietrich
> >
> >
>
>