Data transfer between tables and memory

[Lucas Gertenbach]

How does one import/export large blocks of data between Paradox tables and
memory? I want to perform two operations:

1.Post a block of data in memory to a table.
2.Import a selected block of data from a table, perform mathematical operations
on it and display the result, without the need to write anything back.

I can do it by intermediate transfers to/from text files, but as this involves
a lot of data swapping, it seems like a stupid way of doing it. Alternatively,
doing it by reading/posting one row at a time, simply takes too long (it is a
scientific application involving huge amounts of data).

Any help/suggestions will be really appreciated.

Lucas

[M.H. Avegaart]

You could try an in-memory table, e.g. RxLib (http://www.rxlib.com/) or
kbmMemTable (http://www.optical.dk/common/compon.htm).

"Lucas Gertenbach" <jlbach.g...@virgin.net> schreef in bericht
news:zkz76.117$Ed4....@news2-win.server.ntlworld.com...

[Dan Brennand]

Don't know if your data would benefit, but there are several things
that come to mind. One would be to store data directly to and from
arrays using your own data types and binary files. Look at pascal
functions like write, writeln, and filetypes. Haven't done this in
years, but it was very easy as I recall.
Another possibility would be storing arrays or parts of arrays in BLOB
fields in Paradox or ? tables. The idea is to avoid storing each data
point in a separate field in a separate row.
HTH,
Dan

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control:
visit us at www.cmdcsystems.com
[SPAM block: change at to @ in my e-mail address]

[jlucas.gertenbach]

Thanks for the help. I tried out kbmMemTable, it looks quite interesting. I
tried a TBatchMove from a table to kbmMemTable, but the destination in
TBatchMove does not recognize kbmMemTable...

[jlucas.gertenbach]

Thanks for the help! The BLOB field idea works very well, I store the data as comma
separated text.

Lucas

[Richard Carter]

jlucas.gertenbach (jlucas.g...@ntlworld.com) wrote:
: Thanks for the help. I tried out kbmMemTable, it looks quite interesting. I

: tried a TBatchMove from a table to kbmMemTable, but the destination in
: TBatchMove does not recognize kbmMemTable...

I've downloaded kbmMemTable and taken a look at it, but not used it
in any projects yet. I do remember reading that the Pascal unit
includes a routine that's functionally like tBatchMove, but made to
be compatible with kbmMemTable. Best place to look for further info
and answers is the web discussion group devoted specifically to the
kbmMemTable, which should be mentioned in your readme file.
--
Rick Carter
cart...@email.uc.edu