Client Data Sets

rbuser

I am trying to use the client Data set as my source of report information to
prevent users from having to load the BDE (which I understand is going away)
and because I want to save the temporary information with each project
created in my custom program, not combined on a central database. The
database files are really just used for the reports and not any other
function.

This seems to work fine except I do not know how to combine several
clientDatasets into a query to form one data pipeline. Whenever I try to
use the query wizard, I am forced to use some sort of database server when I
just want to read in the data from the physical files. Is there anyway
around this?

In the past I have used the text method of pipelines, but that leads to alot
of duplicated data because I cannot create queries and the data has to be
written out in a specific sorted order.

I realize this is probably a newbie question, but I would appreciate any
suggestions.

Karen

nicocizik

Karen,

Check out the Custom Dataview Templates Demo at \RBuilder\Demos\3.
EndUser\2. Custom Data Views. Using Custom Dataviews with a JITPipeline or
a TextPipeline would probably be your best bet in this situation.

--

rbuser

I'm already writing to text pipelines and that gets too cumbersome because
of the lack of query options for them - you end up writing out way too many
text files. I was trying to avoid that without making my customers load
database server software. I'm guessing that since this is the suggested
solution, there is not a way to build a query based on clientDataSets.

Thanks for you help,
Karen

nicocizik

Karen,

You will need to either create a database and make your customers load the
server software or you could try using an 'in-memory' dataset. An example
of an in-memory dataset is given by a product called Asta
(http://www.astatech.com). There is also kbmMemTable you can find on
Torry's Delphi web page. (http://www.torry.net).

--