🚀 go-pugleaf

Hi,

Didn't know about this feature, seems to be very clever. I'll try it and let
you know!

By the way, My APP is really neat, on the client side I use serial-Terminals
as cash-registers (www.orderman.com) . For anyone who needs to build simple
stable app's for shops its a cool solution.

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
> >
> >
>
>