More Info/Support on TBufDataSet
lazarus / 16-Databases

----------------------------------------------------------------------
99Percent · 2011-11-11 15:25

I think TBufDataset has great potential for more support and
development. I am particularly interested in adding SQL support
(TSQLBufdataset?) to differ updates to the server or load into memory
isolated reads.

I am trying to find more info on this component but its development
seems to be abandoned. I am willing to try to work on it but before it
would be helpful if there has been other work done. Right off the bat
I can see that some properties can be published in TBufDataset (from
TCustomBufDataset) with no problems. But by looking at the code
ApplyUpdates() seems completely nonfunctional.

Has anyone looked into this component recently?

----------------------------------------------------------------------
tatamata · 2011-11-11 16:51

Hi!
That's exactly what I tried to accomplish with ZMSQL package. You
could join this effort.
http://wiki.lazarus.freepascal.org/ZMSQL
http://sourceforge.net/projects/lazarus-ccr/files/zmsql/

See thread:
http://www.lazarus.freepascal.org/index.php/topic,13821.0.html

----------------------------------------------------------------------
99Percent · 2011-11-11 21:52

I have seen your package but that is not what I am looking for. Your
object is to support SQL directly to the in memory tables. I want more
like Delphi's ClientDataSet functionality over an already existing
client-server database:

1. Specify a different SQL to SELECT, UPDATE, INSERT.
2. Buffer edits to the underlying dataset and then apply them
seperately with ApplyUpdates.
3. Specify how many records to retrieve at a time for very large
dataset and automatically do so when scrolling.
etc

----------------------------------------------------------------------
99Percent · 2011-11-11 23:32

I am realizing just now that TSQLQuery has almost all the
functionality I am looking for so I guess I should be asking for more
info/development of this component instead of TBufDataset. I was
originally using TSQLQuery but stopped when I realized I needed
buffered edits and to be able to edit even while disconnected from the
database server.